单项选择题

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）

A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancel-based recovery
E.restore the entire database from the most recent backup and start the instance and open the database

<上一题目录下一题>

热门试题

多项选择题YourdatabaseisrunninginNOARCHIVELOGmode.YouwanttoputthedatabaseinARCHIVELOGmode.Whichtwostatementsregardingarchivelogdestinationsaretrue？（）

A.The destination must be global only.
B.A maximum of five destinations can be assigned.
C.A maximum of ten different destinations can be assigned.
D.All the destinations are determined by the server automatically.
E.The destination may be local or remote for a Standby Database.
F.The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

多项选择题Youstartedalongtransaction.Beforecommitting，youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror：ORA-01555：snapshottoooldHowwouldyoupreventsuchanerrorinthefuture？（）

A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual

单项选择题Youspecifiedextentmanagementaslocalforatablespace.Howwillitaffectspacemanagementinthetablespace？（）

A.All the extents will be of the same size.
B.Bitmap will be used to record free and allocated extents.
C.Free extents will be managed by the data dictionary tables.
D.The tablespace will be system managed and the users cannot specify the extent size.

单项选择题YouexecutedtheSTARTUPMOUNTcommandtostartyourdatabase.ForwhichdatabaseoperationdoyouneedtostartthedatabaseintheMOUNTstate？（）

A.renaming the control files
B.dropping a user in your database
C.enabling or disabling redo log archiving
D.dropping a tablespace in your database
E.re-creating the control files， after you lost all the control files in your database

单项选择题When you try to open your database， you receive the following error： ORA-00205： error in identifying controlfile Where would you find the details required to resolve this error？（）

A.audit trail
B.alert log file
C.user trace file
D.online trace file
E.background trace file
F.operating system event viewer