单项选择题
You issued the following statement: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What will be the result of issuing the statement?()
A. The control file will be multiplexed.
B. The control file will be recreated.
C.The script containing the CREATE CONTROLFILE statement will be created.
D. The binary backup of the control file will be created.
相关考题
-
单项选择题
YouaremaintainingthedatabaseinOracle10g.YouareperforminganincompleterecoverybyusingRMANbecauseanimportanttable,EMPLOYEE,isdroppedandpurgedfromtheRecycleBin.WhichstatementisNOTtrueregardinganincompleterecovery?()
A. The target database must be in the MOUNT mode to ensure restoration of the datafiles.
B. You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
C. The control file must be recreated.
D. The database must be opened with the RESETLOGS option. -
单项选择题
YouaremaintainingyourdatabaseinARCHIVELOGmode.Animportanttable,SCOTT.EMPLOYEE,isdroppedandpurgedfromtheRecycleBinonMondayat2:00P.M.YoudonotuseRMANtoperformbackups.Youperformedthelastfulluser-managedbackupat9:00P.M.onSunday.Howwillyourecoverthedroppedtable,SCOTT.EMPLOYEE?()
A. by using the Flashback Table feature
B. by using the Flashback Database feature
C. by performing incomplete recovery using RMAN utility
D. by performing incomplete recovery using user-managed recovery -
单项选择题
You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement: SQL>ALTER DATABASE OPEN RESETLOGS; What will be the resultant log sequence numbers?()
A. 0 and 1
B. 1 and 2
C. 1005 and 1006
D. 1006 and 1007
