Oracle DBA 逻辑备份试题选1 (2)
整理：Macro Zeng 　2001-03-20 11:34:09

　　


　　1


　　Q. 13 : Import Utility can be used for the following

　　1. Extract Data from a valid export file
　　2. Recover from user failure errors when a table is accidentally dropped
　　3. Create table definitions since they are stored in export file
　　4. All of the above


　　4


　　Q. 14 : What sequence is followed during an import

　　1. Tables, Indexes, Triggers, Constraints
　　2. Tables, Triggers, Constraints, Indexes
　　3. Tables, Indexes, Sequences, Constraints, Triggers
　　4. None of the above

　　1





　　Q. 15 : Which step of the query process is by passed by direct-path export

　　1. SQL Command Processing Layer
　　2. Space Management
　　3. Buffer Cache Management
　　4. All of the above


　　1



　　Q. 16 : This utility can be used to create a logical backup of an object or entire database

　　1. SQL LOADER
　　2. EXPORT
　　3. IMPORT
　　4. None of the above


　　2



　　Q. 17 : Data Loss can occur if you use an Export / Import Strategy Because

　　1. Rollback Segment contents are Not written to the Export file
　　2. Archive Log Contents Cannot be Applied After an Import
　　3. Export may fail due to Referential Integrity constraints
　　4. None of the above


　　2



　　Q. 18 : The best strategy to recover from user errors like dropped or truncated tables is

　　1. Complete Database Recovery
　　2. Incremental DB Recovery
　　3. Export / Import
　　4. None of the above


　　3



　　Q. 19 : Which of the following is a valid export command

　　1. EXP file=exp.dmp log=exp.log FULL=Y TABLE=emp
　　2. EXP file=exp.dmp log=exp.log DIRECT=Y FULL=Y
　　3. EXP file=exp.dmp log=exp.log COMPRESS=Y ACCESS=N
　　4. None of the above



　　2 : you cannot specify 2 levels in the same statement; Access=N is not a valid Parameter


　　Q. 20 : The following modes of export are supported in oracle 8

　　1. Table
　　2. User
　　3. Full
　　4. All of the above



　　4



　　Q. 21 : Which of the following commands is invalid

　　1. exp file=exp.dmp full=y
　　2. exp file=exp.dmp full=y compress=y indexes=y
　　3. exp file=exp.dmp compress=n consistent=y indexes=y inctype=complete
　　4. None of the above


　　3 : Must specify full =y incase of an incremental export


　　Q. 22 : The following types of exports can only be performed in a full database mode

　　1. Complete
　　2. Cumulative
　　3. Incremental
　　4. All of the above


　　4


　　Q. 23 : How can you create a file containing the scripts to create indexes from the export

　　1. Using the INDEXFILE Option
　　2. Using the INDEXES option

　　3. All of the above
　　4. None of the above


　　1 : INDEXFILE option can be used during imports to create a file of Index and Table creation scripts.


　　Q. 24 : When does Import generate less redo

　　1. Commit=y
　　2. Destroy=y
　　3. Consistent=y
　　4. RecordLength=2*block_size


　　1

　　jsp001.com提供

|首　页||上一页|