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.
12. What Oracle backup and recover file contains user and system data?
- Control file
- Datafile
- OnLine ReDo file
- Offline ReDo file
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.
14. Which SQL phrase is not supported by Oracle?
- ON DELETE CASCADE
- ON UPDATE CASCADE
- CREATE SEQUENCE [SequenceName]
- DROP SEQUENCE [SequenceName]
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
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]
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.
19. To obtain the structure of an Oracle table, the command to use is:
- STRUCTURE [TableName].
- DESCRIBE [TableName].
- DESCRIBE STRUCTURE [TableName].
- DESC TABLE [TableName].