单项选择题

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

A. the RMAN LIST command
B. the DBNEWID utility
C. the RMAN REPORT command
D. the RMAN BLOCKRECOVER command
E. the RMAN CROSSCHECK command
F. the ANALYZE command

点击查看答案

上一题目录下一题

相关考题

单项选择题

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table

单项选择题

In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：
1.RESTORE CONTROLFILE；
2.RESTORE DATABASE；
3.ALTER DATABASE MOUNT；
4.SQL ALTER TABLESPACE temp ADD TEMPFILE
5.ALTER DATABASE OPEN RESETLOGS；
6.RECOVER DATABASE；
7.STARTUP NOMOUNT；
In what sequence would you use this process to perform the recovery？（）

A. 2， 7， 3， 5， 1， 6， 4
B. 2， 1， 7， 6， 3， 5， 4
C. 7， 1， 3， 2， 6， 5， 4
D. 7， 2， 3， 1， 4， 6， 5

单项选择题

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

A. The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
B. Before the instance starts， you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens， but every attempt to write to redo log files fails with an error.