CMS专题
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With refer
题目
timebased recovery
log sequence recovery
cancelbased recovery
changebased recovery
相似问题和答案
第1题：
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）
- A、restore datafiles until time '09/28/2008:21:03:11'
- B、restore database files until time '09/28/2008:18:00:00'
- C、restore database until time '09/28/2008:18:00:00'
- D、recover database until time '09/28/2008:18:00:00'
- E、recover database until timestamp '09/28/2008:18:00:00'
正确答案:C
第2题：
In which scenario will you use the Flashback Transaction Query feature？（）
- A、 when you want to restore an important table that is dropped from the Recycle Bin
- B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
- C、when you want to restore a dropped user’s schema
- D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
正确答案:B
第3题：
A. &
B. ACCEPT
C. PROMPT
D. &&
第4题：
In which scenario will you issue the following command？（） SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING BACKUP CONTROLFILE；
- A、 when all the control files are missing and only a binary backup of the current control file exists
- B、 when a multiplexed copy of the current control file is missing
- C、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
- D、 when the SPFILE is missing
正确答案:A
第5题：
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
- A、timebased recovery
- B、log sequence recovery
- C、cancelbased recovery
- D、changebased recovery
正确答案:C
第6题：
You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）
- A、 A user table was lost at the specified time.
- B、 A redo log file was lost at the specified time.
- C、 The backup control file is on a faster disk than the current one.
- D、 The current control file has a different path compared with the intended time of recovery.
- E、 The current control file does not match the physical structure of the database at the intended time of recovery.
正确答案:E
第7题：
You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database open
- A、 b， d， e
- B、 b， d， f
- C、 c， a， b， d， e
- D、 c， a， b， d， f
- E、 a， b， d， e
正确答案:A
第8题：
You are the network administrator for Ezonexam.
The network includes a Windows 2000 Server computer that contains a single 36-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 4 GB in size and contains the operating system files. Partition D is 32 GB in size and contains user data that is updated frequently.
Both partitions are formatted as NTFS. Both partitions are backed up to a tape every evening at 11:00 P.M.You have a current Emergency Repair Disk (ERD) for the computer, and Recovery Console is installed on the computer.
One day at2:00 P.M., the server fails. You attempt to restart the computer, but you receive the following error message: "Boot disk or operating system not found." You use Recovery Console to discover that the files on partition C are corrupted.
You want to recover the server from the failure as quickly as possible. You also want to recover as much user data as possible.
What should you do?
A．Start the computer by using a Windows 2000 Server compact disc. Select the Repair option in Setup.
B．Install a second hard disk in the computer. Install Windows 2000 Server on the new hard disk. Re-create the shared folders on the first hard disk.
C．Use a Windows 2000 Server boot floppy disk to start the computer. Replace the corrupted files on partition C by copying them from the Emergency Repair Disk.
D．Boot to the Recovery Console. Copy any files that have changed since 11:00 P.M. the previous evening to a second server. Use the most recent tape backup to restore the remaining user data to the second server.
解析：Explanation:Therearefourwaystoperform.anattendedinstallation:1.BoottoaCD-ROM,therebyinvokingthesetuproutine.2.BoottoacurrentoperatingsystemwithCD-ROMsupportandmanuallyinvokethesetuproutine.3.BoottoasetoffoursetupdisksandthenprovidetheCD-ROMwhenprompted.4.Boottoanetwork-awareoperatingsystemandinvokesetupoverthenetwork.IfyouhaveacomputerwhoseBIOSsupportsbootingfromaCD-ROM,youcansetupWindows2000Serverwithoutinstallinganoperatingsystemonyourharddriveandwithoutrequiringnetworksupport.Todoso,configureyourcomputertoboottotheCD-ROMintheBIOS.IntheabovescenariotheserverfailedandforyoutorecovertheserverasquicklyaspossibleandrecoveringasmuchdataaspossibleyouneedtousetheWindows2000ServerCDandselecttheRepairoptioninSetup.Incorrectanswers:B:Thisoptionwillnotbethebesttofollowiftheserveristoberecoveredwithintheshortestpossibletime.Youwillalsolosesomedatasincere-creatingthesharedfoldersonthefirstharddiskwouldalreadyhavedatamissingsincePartitionCiscorrupted.C:EmergencyRepairDiskenablesyoutorecoverfromRegistrysettingsthatrenderyoursysteminoperable.ThismightbemisconfigurationthatcouldnotbecaughtwiththeLastKnownGoodConfiguration,oritmightbedeleteduseraccountsorotherRegistrychanges.Thisisnotaregistryproblem.TheEmergencyRepairDiskcanbeusedtofacilitatesomesystemrepairsonyourWindows2000server.Essentially,thediskcanbeusedtorepairstartupproblems,likewhenessentialstartupfilesarenotpresentandyourServerrefusestoboot.However,thisproblemneedstobeaddressesasquicklyaspossibleandmakinguseoftheRepairoptioninSetupfromtheWindows2000ServerCDwouldbethequickermethod.D:TheRecoveryconsoleisapowerfultext-basedbootalternativeforWindows2000Server.Ifyoursystembecomessocorruptthatitwillnotbootandnootherrepairprocesswillhelp,youcanboottotheRecoveryconsoleandcopyfilestoorfromyourserver.Inaddition,youcanstopandstartservices,ifaservicethatyouhaveinstalledcausesproblemswithbooting.Thisoptiondoesnotrepresentthequickestwaytoaddresstheproblemathand.
第9题：
You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace. Which two clauses can you use with the RECOVER command？（）
- A、 UNTIL SEQUENCE
- B、 UNTIL SCN
- C、 UNTIL CHANGE
- D、 UNTIL CANCEL
正确答案:C,D
第10题：
You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover？（）
- A、 all the datafiles in the database
- B、 the datafiles associated with the SYSTEM tablespace
- C、 the datafiles associated with the DATA1 tablespace
- D、 all the datafiles in the database except those associated with the DATA1 tablespace
正确答案:D