单项选择题
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
相关考题
-
单项选择题
YouareworkingonanOracleDatabase10gdatabasethatoperatesintheARCHIVELOGmode.At06：00p.m.，youdiscoveredthatatableintheSYSTEMtablespacethatdoesnotbelongtothedatadictionarywasdroppedat03：00p.m.Whatwouldyoudotorecoverthetable？（）
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 -
单项选择题
Youareworkingonadatabase，whereyouhavethreeredologgroups.Whenthedatabaseisdownforabackup，anoperatingsystem（OS）userdeletesalltheredologfilesinagroup.Whatwillhappenwhenyouopenyourdatabase？（）
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.
