Managing Database with Oracle Questions and Answers

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

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test