Oracle DBA逻辑备份试题

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 user error4. None of the above3Q. 3 : What are the 3 levels of Exports1. GLOBAL, USER, TABLESPACE2. FULL, USER, TABLE3. FULL, TABLESPACE, TABLE4. GLOBAL, LOCAL, TRANSACTIONAL2Q. 4 : The following methods can be used to run

3、 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 an Export utility1. LOG2. STATISTICS3. DIRECT4. All of the Above4Q. 6 : What Incremental Parameters can be used

4、 with exports1. INCTYPE = complete2. INCTYPE = cumulative3. INCTYPE = Incremental4. All of the above4Q. 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 last export2. 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. Applicati

6、ons with few large tables and less data changes2. Applications where changes are scattered across small tables3. All of the above4. None of the above2Q. 10 : What is a Cumulative Export1. Export of the objects that have changed since last export2. Export of objects that have changed since last cumul

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

8、ption By Passes the SQL Layer2. 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

9、 are stored in export file4. 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 pas

10、sed by direct-path export1. SQL Command Processing Layer2. Space Management3. 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 u

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

12、pped or truncated tables is1. Complete Database Recovery2. 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.

13、log 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=ex

14、p.dmp full=y2. exp file=exp.dmp full=y compress=y indexes=y3. 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 abo