导入与导出试思选 货源介绍：Q.I:hat option of Exporting allows quicker data extractions 1.Grants "y 2.Consistent =y 3.Direct true 4.Direct=y 4:Direct=y option bypasses the SCL layer to allow quicker data extractions Q.2 Bow are exports useful 1.Can be used to recover to a point in time 2.Can be used to recover from a nedia failure 3.Can be used to recover dropped tables due a user error 4.None of the above 3 Q.3 What are the 3 levels of Exports 1.GLOBML,USER,TABLESPACE 2.FULL USER.TABLE 3FUL,TA以ESPACE.TABLE 4.GLOBML,LOCAL,TRANSACTIONAL 2 Q.4 The following methods can be used to run exports 1.Interactive Dialog 2.Export Section of Data Manager in OEM 3.Command Line Interface with parameter file 4.All of the above 4 Q5 Which of the following are valid paraneters for an Export utility 1.L0G 2.STATISTICS 3.DIRECT
导入与导出试题选 资源介绍：Q. 1 : What option of Exporting allows quicker data extractions 1. Grants =y 2. Consistent =y 3. Direct = true 4. Direct=y 4 : Direct=y option bypasses the SQL layer to allow quicker data extractions Q. 2 : How are exports useful ? 1. Can be used to recover to a point in time 2. Can be used to recover from a media failure 3. Can be used to recover dropped tables due a user error 4. None of the above 3 Q. 3 : What are the 3 levels of Exports 1. GLOBAL, USER, TABLESPACE 2. FULL, USER, TABLE 3. FULL, TABLESPACE, TABLE 4. GLOBAL, LOCAL, TRANSACTIONAL 2 Q. 4 : The following methods can be used to run exports 1. Interactive Dialog 2. Export Section of Data Manager in OEM 3. Command Line Interface with parameter file 4. All of the above 4 Q. 5 : Which of the following are valid parameters for an Export utility 1. LOG 2. STATISTICS 3. DIRECT
4.All of the Above Q.6 What Incremental Parameters can be used vith exports 1.INCTYPE coaplete 2.INCTYPE cumulative 3.INCTYPE Incremental 4.All of the above Q.7 What can you do to reduce the burden on a rollback segment during the import of a large table 1.Assign a Large Rollback Segnent 2 SET TRANSACTION USE ROLLBACK SEGMENT RBSLARGE 3.COMMIT=Y 4.None of the above Q.8 What is an Increrental Export 1.Export of the objeets that have changed since last export 2.Export of rows that have changed since last export 3.Incremental Exports cannot be performed in Oracle 4.None of the above Q9 An Incremental Export is a good strategy for 1.Applications with few large tables and less data changes 2.Applications where changes are scattered across small tables 3.All of the above 4.None of the above 2 Q.10 What is a Cunlative Export 1.Export of the objects that have changed since last export 2.Export of objects that have changed since last cumulative or complete export
4. All of the Above 4 Q. 6 : What Incremental Parameters can be used with exports 1. INCTYPE = complete 2. INCTYPE = cumulative 3. INCTYPE = Incremental 4. All of the above 4 Q. 7 : What can you do to reduce the burden on a rollback segment during the import of a large table 1. Assign a Large Rollback Segment 2. SET TRANSACTION USE ROLLBACK SEGMENT RBSLARGE 3. COMMIT=Y 4. None of the above 3 Q. 8 : What is an Incremental Export 1. Export of the objects that have changed since last export 2. Export of rows that have changed since last export 3. Incremental Exports cannot be performed in Oracle 4. None of the above 1 Q. 9 : An Incremental Export is a good strategy for 1. Applications with few large tables and less data changes 2. Applications where changes are scattered across small tables 3. All of the above 4. None of the above 2 Q. 10 : What is a Cumulative Export 1. Export of the objects that have changed since last export 2. Export of objects that have changed since last cumulative or complete export
3.Export or rows that have changed since last cumualative or complete export 4.None of the above 2 Q.11 What option of export utility allows for faster extraction of data 1.FULL-y 2 DIRECT=Y 3.SQL=N 4.All of the above 2 [NextPage] Q12 Why is Direct Path Export Faster 1.This option By Passes the SQL.Layer 2.All SGA is used for Export 3.All of the above 4.None of the above 1 Q.13 Import Utility can be used for the following 1.Extract Data from a valid export file 2.Recower fro user failure errors whem 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 hy passed by direct-path export 1.SQL Command Processing Layer
3. Export or rows that have changed since last cumulative or complete export 4. None of the above 2 Q. 11 : What option of export utility allows for faster extraction of data 1. FULL=y 2. DIRECT=Y 3. SQL=N 4. All of the above 2 [NextPage] Q. 12 : Why is Direct Path Export Faster 1. This option By Passes the SQL Layer 2. All SGA is used for Export 3. All of the above 4. None of the above 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.IVPORT 4.None of the above 2 Q.17 Data Loss can occur if you use an Export Inport Strategy Because 1.Rollback Sepment 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 气 Q18 The best strategy to recover from user errors like dropped or truncated tables is 1.Complete Database Recovery 2.Incremental DB Recovery 3 Export/I国ort 4.None of the above 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 sane statement:Access"N is not a valid
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
Paraneter Q20 The following modes of export are supported in oracle 8 1.Table 2 User 3.Full 4.All of the above 4 Q21 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 filemexp.dmp compress"n comsistent"y indexes"y inctypemcomplete 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 aode I.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 I INDEFILE optioe can be used during imports to create a file of Index and Table creation scripts. Q.24 When does Import gemerate less redo 1.Comit=y
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
2. Destroy=y 3. Consistent=y 4. RecordLength=2*block_size