文档介绍:Oracle DBA 逻辑备份试题选
Q. 1 : What option of Exporting allows quicker data extractions
Grants =y
Q. 10 : What is a Cumulative Export
Export of the objects that have changed since last
export
Export of objects that have changed since last cumulative or complete export
Export or rows that have changed since last cumulative
or complete export
None of the above
Q. 11 : What option of export utility allows for faster
extraction of data
FULL=y
DIRECT=Y
SQL=N
All of the above
[NextPage]
Q. 12 : Why is Direct Path Export Faster
1. This option By Passes the SQL Layer
4
All SGA is used for Export
All of the above
None of the above
1
Q. 13 : Import Utility can be used for the following
Extract Data from a valid export file
Recover from user failure errors when a table is accidentally dropped
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
Tables, Indexes, Triggers, Constraints
Tables, Triggers, Constraints, Indexes
Tables, Indexes, Sequences, Constraints, Triggers
None of the above
1
Q. 15 : Which step of the query process is by passed by direct-path expo