单项选择题
You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace, DATA1, was dropped and purged from the Recycle Bin. After performing an incomplete recovery, you open the database with the RESETLOGS option. What will NOT be the impact of using the RESETLOGS option?()
A. The log sequence for the database will restart from 1.
B. The log sequence number will be written to the control file.
C. The log sequence number will be written to the datafile headers.
D. The log sequence number will be written to the initialization parameter file.
相关考题
-
单项选择题
Youissuedthefollowingstatement:SQL>ALTERDATABASEBACKUPCONTROLFILETOTRACE;Whatwillbetheresultofissuingthestatement?()
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
