单项选择题
To view the results of the most recent Automatic SQL Tuning Advisor task,which sequence should you follow?()
A. EM Database home page,Software and Support,SQL Advisors,Automatic SQL Tuning Advisor
B. EM Database home page,Software and Support,Advisor Central,SQL Advisors,Automatic SQL Tuning Advisor
C. EM Database home page,Software and Support,Support Workbench,Advisor Central,SQL Advisors,Automatic SQL Tuning Advisor
D. Either B or C
E. All of the above
相关考题
-
单项选择题
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?()
A.A
B.B
C.C
D.D
-
多项选择题
While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?()
A. RECOVER FILE=1201 BLOCK=1968
B. RECOVER CORRUPTION LIST
C. RECOVER DATAFILE 1201 BLOCK 1968
D. RECOVER BLOCK CORRUPTION LIST
E. None of the above -
多项选择题
Whichofthefollowingarecorrectaboutblockmediarecovery?()
A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
B. Logical corruptions are repairable by BMR
C. Physical corruptions are repairable by BMR
D. RMAN can use any backup for a BMR restore
E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore
