Database - Managing Database with Oracle

Database - Managing Database with Oracle
11. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
  • Using the Oracle Database Configuration Assistant.
  • Using the Oracle-supplied database creation procedures.
  • Using the SQL CREATE DATABASE command.
  • None of the above is correct.
Show Answer
12. What Oracle backup and recover file contains user and system data?
  • Control file
  • Datafile
  • OnLine ReDo file
  • Offline ReDo file
Show Answer
13.  When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
  • are case insensitive.
  • are case sensitive.
  • must always be in lower case.
  • must always be in upper case.
Show Answer
14.  Which SQL phrase is not supported by Oracle?
  • ON DELETE CASCADE
  • ON UPDATE CASCADE
  • CREATE SEQUENCE [SequenceName]
  • DROP SEQUENCE [SequenceName]
Show Answer
15. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  • Full backup
  • Consistent backup
  • Inconsistent backup
  • Differential backup
Show Answer
16. 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?
  • Open [FileName]
  • Show [FileName]
  • Alter [FileName]
  • Edit [FileName]
Show Answer
17. The default extension for an Oracle SQL*Plus file is:
  • .txt.
  • .pls.
  • .ora.
  • .sql.
Show Answer
18. An Oracle System Change Number (SCN):
  • is a value that is incremented whenever a dirty read occurs.
  • is incremented whenever a deadlock occurs.
  • is a value that keeps track of explicit locks.
  • is a value that is incremented whenever database changes are made.
Show Answer
19. To obtain the structure of an Oracle table, the command to use is:
  • STRUCTURE [TableName].
  • DESCRIBE [TableName].
  • DESCRIBE STRUCTURE [TableName].
  • DESC TABLE [TableName].
Show Answer
20. To see the contents of the SQL*Plus buffer, type:
  • CONTENTS.
  • BUFFER.
  • CURRENT.
  • LIST.
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test