OracleDBA逻辑备份试题选.doc

1、Oracle DBA逻辑备份试题选Q. 1 : What option of Exporting allows quicker data extractions1. Grants =y2. Consistent =y3. Direct = true4. Direct=y4 : Direct=y option bypasses the SQL layer to allow quicker data extractionsQ. 2 : How are exports useful ?1. Can be used to recover to a point in time2. Can be used

2、 to recover from a media failure3. Can be used to recover dropped tables due a usererror4. None of the above3Q. 3 : What are the 3 levels of Exports1. GLOBAL, USER, TABLESPACE2. FULL, USER, TABLE3. FULL, TABLESPACE, TABLE14. GLOBAL, LOCAL, TRANSACTIONAL2Q. 4 : The following methods can be used to ru

3、n exports1. Interactive Dialog2. Export Section of Data Manager in OEM3. Command Line Interface with parameter file4. All of the above4Q. 5 : Which of the following are valid parameters for anExport utility1. LOG2. STATISTICS3. DIRECT4. All of the Above4Q. 6 : What Incremental Parameters can be used

4、 withexports1. INCTYPE = complete2. INCTYPE = cumulative3. INCTYPE = Incremental4. All of the above42Q. 7 : What can you do to reduce the burden on a rollback segment during the import of a large table1. Assign a Large Rollback Segment2. SET TRANSACTION USE ROLLBACK SEGMENT RBSLARGE3. COMMIT=Y4. Non

5、e of the above3Q. 8 : What is an Incremental Export1. Export of the objects that have changed since lastexport2. Export of rows that have changed since last export3. Incremental Exports cannot be performed in Oracle4. None of the above1Q. 9 : An Incremental Export is a good strategy for1. Applicatio

6、ns with few large tables and less data changes2. Applications where changes are scattered across smalltables3. All of the above4. None of the above32Q. 10 : What is a Cumulative Export1. Export of the objects that have changed since lastexport2. Export of objects that have changed since last cumulat

7、ive or complete export3. Export or rows that have changed since last cumulativeor complete export4. None of the above2Q. 11 : What option of export utility allows for fasterextraction of data1. FULL=y2. DIRECT=Y3. SQL=N4. All of the above2NextPageQ. 12 : Why is Direct Path Export Faster1. This optio

8、n By Passes the SQL Layer42. All SGA is used for Export3. All of the above4. None of the above1Q. 13 : Import Utility can be used for the following1. Extract Data from a valid export file2. Recover from user failure errors when a table is accidentally dropped3. Create table definitions since they ar

9、e stored in exportfile4. All of the above4Q. 14 : What sequence is followed during an import1. Tables, Indexes, Triggers, Constraints2. Tables, Triggers, Constraints, Indexes3. Tables, Indexes, Sequences, Constraints, Triggers4. None of the above1Q. 15 : Which step of the query process is by passed

10、by direct-path export1. SQL Command Processing Layer2. Space Management53. Buffer Cache Management4. All of the above1Q. 16 : This utility can be used to create a logical backup of an object or entire database1. SQL LOADER2. EXPORT3. IMPORT4. None of the above2Q. 17 : Data Loss can occur if you use

11、an Export / ImportStrategy Because1. Rollback Segment contents are Not written to the Export file2. Archive Log Contents Cannot be Applied After anImport3. Export may fail due to Referential Integrity constraints4. None of the above2Q. 18 : The best strategy to recover from user errors like dropped

12、or truncated tables is1. Complete Database Recovery62. Incremental DB Recovery3. Export / Import4. None of the above3Q. 19 : Which of the following is a valid export command1. EXP file=exp.dmp log=exp.log FULL=Y TABLE=emp2. EXP file=exp.dmp log=exp.log DIRECT=Y FULL=Y3. EXP file=exp.dmp log=exp.log

13、COMPRESS=Y ACCESS=N4. None of the above2 : you cannot specify 2 levels in the same statement; Access=N is not a valid ParameterQ. 20 : The following modes of export are supported in oracle 81. Table2. User3. Full4. All of the above4Q. 21 : Which of the following commands is invalid1. exp file=exp.dm

14、p full=y2. exp file=exp.dmp full=y compress=y indexes=y73. exp file=exp.dmp compress=n consistent=y indexes=y inctype=complete4. None of the above3 : Must specify full =y incase of an incremental exportQ. 22 : The following types of exports can only be performed in a full database mode1. Complete2. Cumulative3. Incremental4. All of the above4Q. 23 : How can you create a file containing the scripts to create indexes from the export1. Using the INDEXFILE Option2. Using the INDEXES option3. All of the above4. None of the above1 :