单选题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 time-based recoveryB log sequence recoveryC cancel-based recoveryD change-based recovery
单选题
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
time-based recovery
B
log sequence recovery
C
cancel-based recovery
D
change-based recovery
参考解析
解析：
暂无解析
相关考题：
Which substitution variable would you use if you want to reuse the variable without prompting the user each time? () A. B. ACCEPTC. PROMPTD.
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.
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'
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.
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 BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 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
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 openA、 b， d， eB、 b， d， fC、 c， a， b， d， eD、 c， a， b， d， fE、 a， b， d， e
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 recoveryB、log sequence recoveryC、cancelbased recoveryD、changebased recovery
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 SEQUENCEB、 UNTIL SCNC、 UNTIL CHANGED、 UNTIL CANCEL
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 existsB、 when a multiplexed copy of the current control file is missingC、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD、 when the SPFILE is missing
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 databaseB、 the datafiles associated with the SYSTEM tablespaceC、 the datafiles associated with the DATA1 tablespaceD、 all the datafiles in the database except those associated with the DATA1 tablespace
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）A、B、ACCEPTC、PROMPTD、
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
单选题You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）ARMAN BACKUP DURATION 2:00 MINIMIZE LOAD DATABASEBRMAN BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASECRMAN BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE DRMAN BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE
单选题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 existsB when a multiplexed copy of the current control file is missingCwhen all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD when the SPFILE is missing
单选题You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL RECOVER DATABASE 2 UNTIL TIME ’2004/x7f08/x7f05：12：10：03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required？（）AA user table was lost at the specified time.BA redo log file was lost at the specified time.CThe backup control file is on a faster disk than the current one.DThe current control file has a different path compared with the intended time of recovery.EThe current control file does not match the physical structure of the database at the intended time of recovery.
单选题A user on your network downloads a video card driver from the Internet. You are unsure of the source of the driver. You want to ensure that the user does not lose production time because of an incompatible driver. What should you do?（）AInstall the driver into the computer. Restart the computer. Use the last known good configuration to recover the original driver if necessary. BInstall the driver in the computer. Use the hardware troubleshooter and then use the recovery console to recover the original driver if necessary. CDisplay the advanced attributes of the video card driver file. Install the file only if the contents have been secured. DRun file signature verification utility to verify that the driver has been digitally signed.
单选题Which command would correctly start a TSPITR of the USERS tablespace？（）A recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliaryB recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliaryC recover tablespace users to point-in.D recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliaryE recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
单选题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 openA b， d， eB b， d， fC c， a， b， d， eD c， a， b， d， fE a， b， d， e
单选题Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）ABACCEPTCPROMPTD
单选题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.
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）AOnly the SET command must be within a RUN block.BAll commands should be executed at the RMAN prompt.CAll three commands must be within a single RUN block.DOnly the RESTORE and RECOVER commands must be within a single RUN block.
单选题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？（）Atimebased recoveryBlog sequence recoveryCcancelbased recoveryDchangebased recovery
单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）ASetting a metric thresholdBImplementing Database Resource ManagerCEnabling resumable timeout for user sessionsDDecreasing the value of the IDLE_TIME resource limit in the default profile
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）AComplete Recovery with online redo logBComplete Recovery with archived redo logCTablespace Point-in-Time Recovery (TSPITR)DIncomplete Recovery with system change number (SCN)
单选题In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）A Complete Recovery with online redo logB Complete Recovery with archived redo logC Tablespace Point-in-Time Recovery （TSPITR）D Incomplete Recovery with system change number （SCN）
单选题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 BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionCwhen you want to restore a dropped user’s schemaD 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
单选题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 databaseB the datafiles associated with the SYSTEM tablespaceC the datafiles associated with the DATA1 tablespaceD all the datafiles in the database except those associated with the DATA1 tablespace