OracleDBA逻辑备份试题选

1、Oracle DBA逻辑备份试题选Oracle DBA 逻辑备份试题选 Oracle DBA 逻辑备份试题选 q.1 : what optio n of export ing allows quicker data extracti ons1. grants =y2. con siste nt =y3. direct = true4. direct=y4 : direct=y opti on bypasses the sql layer to allow quickerdata extracti onsq. 2 : how are exports useful ?1. can be used

2、to recover to a point in time2. can be used to recover from a media failure3. can be used to recover dropped tables due a user error4. none of the above3iq. 3 : what are the 3 levels of exports1. global, user, tablespace2. full, user, table3. full, tablespace, table4. global, local, tran sacti onal2

3、q. 4 : the follow ing methods can be used to run exports1. i nteractive dialog2. export secti on of data man ager in oem3. comma nd line in terface with parameter file4. all of the above4q. 5 : which of the followingare valid parameters for anexport utility1. log2. statistics3. direct4. all of the a

4、bovewith4q. 6 : what in creme ntalparameters can be usedexports1. i nctype = complete2. i nctype = cumulative3. i nctype = in creme ntal4. all of the above4q. 7 : what can you do to reduce the burde n on a rollback segme nt duri ng the import of a large table1. assig n a large rollback segme nt2. se

5、t tran sacti on use rollback segme nt rbslarge3. commit=y4. none of the above3q. 8 : what is an in creme ntal export1. export of the objects that have changed si nee last export2. export of rows that have cha nged since last export3. i ncreme ntal exports cannot be performed in oracle4. none of the

6、above1q. 9 : an in creme ntal export is a good strategy for1. applicationswith few large tables and less datachanges2. applicati ons where cha nges are scattered across smalltables3. all of the above4. none of the above2q. 10 : what is a cumulative export1. export of the objects that have changed si

7、 nee last export2. export of objects that have changedsince lastcumulative or complete export3. export or rows that have cha nged since last cumulativeor complete export4. none of the above2q. 11 : what option of export utility allows for faster extracti on of data1. full=y2. direct二y3. sq l=n4. all

8、 of the above2q. 12 : why is direct path export faster1. this opti on by passes the sql layer2. all sga is used for export3. all of the above4. none of the abovedataq. 1 : what optionof exportingallows quickerextracti ons1. grants =y2. con siste nt =y3. direct = true4. direct=y4 : direct=y opti on b

9、ypasses the sql layer to allow quickerdata extracti onsq. 2 : how are exports useful ?1. can be used to recover to a point in time2. can be used 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. glob

10、al, user, tablespace2. full, user, table3. full, tablespace, table4. global, local, tran sacti onal2q. 4 : the follow ing methods can be used to run exports1. i nteractive dialog2. export secti on of data man ager in oem3. comma nd line in terface with parameter file4. all of the aboveq. 5 : which o

11、f the following are valid parameters for anexport utility1. log2. statistics3. direct4. all of the above4q. 6 : what in creme ntal parameters can be used withexports1. i nctype = complete2. i nctype = cumulative3. i nctype = in creme ntal4. all of the above4q. 7 : what can you do to reduce the burde

12、 n on a rollbacksegme nt duri ng the import of a large table1. assig n a large rollback segme nt2. set tran sacti on use rollback segme nt rbslarge3. commit=y4. none of the above3q. 8 : what is an in creme ntal export1. export of the objects that have changed si nee last export2. export of rows that

13、 have cha nged since last export3. i ncreme ntal exports cannot be performed in oracle4. none of the aboveq. 9 : an in creme ntal export is a good strategy for1. applicationswith few large tables and less datachanges2. applicati ons where cha nges are scattered across small tables3. all of the above4. none of the a