Sail E0 Webinar

MCQs

Total Questions : 66 | Page 7 of 7 pages
Question 61. . 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].
 Discuss Question
Answer: Option B. -> DESCRIBE [TableName].
Question 62. . 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
 Discuss Question
Answer: Option B. -> Consistent backup
Question 63. . The default extension for an Oracle SQL*Plus file is:
  1.    .txt.
  2.    .pls.
  3.    .ora.
  4.    .sql.
 Discuss Question
Answer: Option D. -> .sql.
Question 64.
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]
 Discuss Question
Answer: Option D. -> Edit [FileName]
Question 65. . 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.
 Discuss Question
Answer: Option D. -> is a value that is incremented whenever database changes are made.
Question 66. . To see the contents of the SQL*Plus buffer, type:
  1.    CONTENTS.
  2.    BUFFER.
  3.    CURRENT.
  4.    LIST.
 Discuss Question
Answer: Option D. -> LIST.

Latest Videos

Latest Test Papers