多項選擇題

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？（）

A. Restore the lost data file from the backup， and then flash back the database.
B. Restore the data file pertaining to index tablespace， and then recover the tablespace.
C. Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
D. Restore all the data files， and then perform an incomplete recovery using the backup control file.
E. Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

你可能感興趣的試題

多項選擇題

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：
ERROR at line 1：
ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

A. Drop and re-create the inbox.
B. Coalesce the ORDERS_IND index.
C. Coalesce the INDEXES tablespace.
D. Drop and re-create the ORDERS table.
E. Rebuild the index online and move it to another tablespace.

單項選擇題

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）

A. LogMiner
B. The DBNEWID utility
C. The DBVERIFY utility
D. The ANALYZE command
E. The RMAN REPORT command
F. The RMAN CROSSCHECK command.
G. The RMAN BLOCKRECOVER command.

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

你可能感興趣的試題

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？（）

You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）