black

1z0-043

登录

单项选择题

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement:  
SQL> DROP TABLE SCOTT.EMP PURGE;  
After one hour, you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup?()

A. the datafiles associated with the SYSTEM tablespace
B. the datafiles associated to the DATA1 tablespace
C. the datafiles associated to the SYSTEM and DATA1 tablespaces
D. all the datafiles in the database

相关考题

单项选择题 YouaremaintainingyourdatabaseinOracle10g.OnTuesdayat8:00A.M.,whilestartingthedatabase,youdiscoverthatallthecontrolfilesaremissing.ThebackupofthefulldatabasewasperformedonSundayat6:00P.M.Whichtypeofrecoverywillyouperform?()

单项选择题 You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQL>ALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()

多项选择题 YouaremaintainingyourdatabaseinOracle10g.Youperformafulluser-managedbackupeverySundayat8:00P.M.YourdatabaseisrunninginARCHIVELOGmode.OnMonday,at9:00A.M.,atablespaceisdropped.Youdecidetoperformincompleterecoverytorecoverthedroppedtablespace.WhichtwoclausescanyouusewiththeRECOVERcommand?()

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号:湘ICP备14005140号-5

经营许可证号:湘B2-20140064