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？（）

相似题目

• When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

  A . Until SCN B . Until time C . Until cancel D . Recover using backup control file.

  查看最佳答案

• You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

  A .  MOUNT mode B .  RESTRICTED mode C .  OPEN mode D .  NOMOUNT mode

  查看最佳答案

• You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）

  A . The backup as copy can only be taken to disk B . The backup as copy can only be taken to tape C . Backup can be performed only when the instance is shutdown D . Backup will constitute all used and unused blocks in the database

  查看最佳答案

• You need to perform an automated installation of an Exchange Server 2010 server. Which command should you include in your script（）？

  A . setup.exe B . setup.com C . msiexec.exe D . lpsetupui.exe

  查看最佳答案

• 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 are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）

  A .  This operation resets the SCN for the database. B .  This operation creates a new incarnation of the database. C .  This operation moves all the redo log files to a different location. D .  This operation deletes the old redo log files and creates new redo log files. E .  This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  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.

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

  A .  open the database with the RESTRICTED option B .  open the database with the RESETLOGS option C .  recover to the required SCN only that data file in which the error occurred D .  recover all the data files to the same system change number （SCN）

  查看最佳答案

• 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

  查看最佳答案

• In which scenario will you perform an incomplete recovery？（）

  A .  when a table is dropped and stored in the Recycle Bin B .  when all the control files are deleted C .  when a member of a multiplexed redo log group is dropped D .  when you are required to recover a table to its previous state

  查看最佳答案

• 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？ （）

  A . Only the SET command must be within a RUN block. B . All commands should be executed at the RMAN prompt. C . All three commands must be within a single RUN block. D . Only the RESTORE and RECOVER commands must be within a single RUN block.

  查看最佳答案

• As a result of a media failure， the current online redo log group is corrupted. The database crashes， as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform？ （）

  A . Cancel-based B . Recovery using a backup control file C . Time-based D . Change-based

  查看最佳答案

• You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

  A .  Whole database B .  Tablespaces C .  Datafiles D .  Archive logs E .  Redo log

  查看最佳答案

• You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

  A .  The backup as copy can only be taken to disk B .  The backup as copy can only be taken to tape C .  Backup can be performed only when the instance is shutdown D .  Backup will constitute all used and unused blocks in the database

  查看最佳答案

• you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

  A .  True B .  False

  查看最佳答案

• In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

  A .  when all the online redo log groups are multiplexed and one of the members of a group is missing B .  when all the online redo log groups are not multiplexed and one log group is missing C .  when all the control files are missing D .  when some important tables are deleted from the database and purged from the Recycle Bi

  查看最佳答案

• You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

  A .  NOMOUNT B .  MOUNT C .  OPEN D .  RESTRICTED

  查看最佳答案

• When performing an incomplete recovery of the whole database， what must be true about the data files that are restored？（）https://assets.asklib.com/images/image2/201808011106595682.jpg

  A . A B . B C . C D . D

  查看最佳答案

• Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）

  A . open the database with the RESETLOGS option B . open the database with the RESTRICTED option C . recover all the data files to the same system change number （SCN） D . recover to the required SCN only that data file in which the error occurred

  查看最佳答案

• You are developing an application that will perform mathematical calculations.You need to ensure that the application is able to perform multiple calculations simultaneously. What should you do？（）

  A . Set the IdealProcessor property of the ProcessThread object. B . Set the ProcessorAffinity property of the ProcessThread object. C . For each calculation， call the QueueUserWorkItem method of the ThreadPool class. D . Set the Process.GetCurrentProcess（）.BasePriority property to High.

  查看最佳答案

• You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

  A . This operation resets the SCN for the database. B . This operation creates a new incarnation of the database. C . This operation moves all the redo log files to a different location. D . This operation deletes the old redo log files and creates new redo log files. E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

  查看最佳答案

• You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

  A .  UNTIL CANCEL B .  UNTIL SCN C .  UNTIL SEQUENCE D .  UNTIL TIME

  查看最佳答案

• You need to perform an automated installation of an Exchange Server 2010 server.Which Command should you include in your script？（）

  A . setup.exe B . setup.com C . msiexec.exe D . lpsetupui.exe

  查看最佳答案