Lakshya Education MCQs

Question: The default extension for an Oracle SQL*Plus file is:
Options:
A..txt
B..pls
C..ora
D..sql
Answer: Option D

Submit Answer & Explaination

Earn Reward Points by submitting Detailed Explaination for this Question

More Questions on This Topic :

Question 1. To obtain the structure of an Oracle table, the command to use is:
  1.    STRUCTURE [TableName].
  2.    DESCRIBE [TableName].
  3.    DESCRIBE STRUCTURE [TableName].
  4.    DESC TABLE [TableName].
Answer: Option B
Question 2. An Oracle System Change Number (SCN):
  1.    is a value that is incremented whenever a dirty read occurs.
  2.    is incremented whenever a deadlock occurs.
  3.    is a value that keeps track of explicit locks.
  4.    is a value that is incremented whenever database changes are made.
Answer: Option D
Question 3. To see the contents of the SQL*Plus buffer, type:
  1.    CONTENTS
  2.    BUFFER
  3.    CURRENT
  4.    LIST
Answer: Option D
Question 4. You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
  1.    Open [FileName]
  2.    Show [FileName]
  3.    Alter [FileName]
  4.    Edit [FileName]
Answer: Option D
Question 5. Which SQL phrase is not supported by Oracle?
  1.    ON DELETE CASCADE
  2.    ON UPDATE CASCADE
  3.    CREATE SEQUENCE [SequenceName]
  4.    DROP SEQUENCE [SequenceName]
Answer: Option B
Question 6. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  1.    Full backup
  2.    Consistent backup
  3.    Inconsistent backup
  4.    Differential backup
Answer: Option B

Check all Questions in this Topic : Click HERE