网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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 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 CANCELB  UNTIL SCNC  UNTIL SEQUENCED  UNTIL TIME” 相关考题
考题 You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? ()A. AB. BC. CD. D

考题 You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()A、 until Thursday morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening

考题 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 databaseB、 TablespacesC、 DatafilesD、 Archive logsE、 Redo logs

考题 You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace, DATA1, was dropped and purged from the Recycle Bin. After performing an incomplete recovery, you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option?()A、 The log sequence for the database will restart from 1.B、 The log sequence number will be written to the control file.C、 The log sequence number will be written to the datafile headers.D、 The log sequence number will be written to the initialization parameter file.

考题 When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required?()A、Thread number.B、Log Sequence number.C、Control file sequence number.D、Name of the last archived log.

考题 Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A、Perform Export before TSPITR and Import after TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

考题 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.

考题 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 CANCELB、 UNTIL SCNC、 UNTIL SEQUENCED、 UNTIL TIME

考题 In which scenario will you perform a user-managed incomplete recovery?()A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period

考题 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

考题 You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A、 user managed complete recoveryB、 user managed incomplete recoveryC、 RMAN-based complete recoveryD、 RMAN-based incomplete recovery

考题 In which situation are you NOT required to perform an incomplete recovery?()A、 when all the control files are lostB、 when all the members of a redo log group are lostC、 when a table is dropped and purged from the Recycle BinD、 when a temporary file of the default temporary tablespace is lost

考题 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

考题 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 modeB、 RESTRICTED modeC、 OPEN modeD、 NOMOUNT mode

考题 You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement:   SQLALTER DATABASE OPEN RESETLOGS;   What will be the resultant log sequence numbers?()A、 0 and 1B、 1 and 2C、 1005 and 1006D、 1006 and 1007

考题 单选题You have performed an incomplete recovery because some important user’s schema is dropped and purged from the Recycle Bin. The current logs are sequenced 1005 and 1006. After performing the recovery, you issued the following statement:   SQLALTER DATABASE OPEN RESETLOGS;   What will be the resultant log sequence numbers?()A  0 and 1B  1 and 2C  1005 and 1006D  1006 and 1007

考题 单选题You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace, DATA1, was dropped and purged from the Recycle Bin. After performing an incomplete recovery, you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option?()A  The log sequence for the database will restart from 1.B  The log sequence number will be written to the control file.C  The log sequence number will be written to the datafile headers.D  The log sequence number will be written to the initialization parameter file.

考题 单选题You are performing a database recovery because a user’s schema is dropped. While performing the recovery, you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing?()A  user managed complete recoveryB  user managed incomplete recoveryC  RMAN-based complete recoveryD  RMAN-based incomplete recovery

考题 单选题In which situation are you NOT required to perform an incomplete recovery?()A  when all the control files are lostB  when all the members of a redo log group are lostC  when a table is dropped and purged from the Recycle BinD  when a temporary file of the default temporary tablespace is lost

考题 单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery,you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object?()A  Perform Export before TSPITR and Import after TSPITRB  Move objects to another schema that has the same tablespace assignedC  Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D  Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

考题 单选题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.

考题 单选题In which scenario will you perform a user-managed incomplete recovery?()A  when a table is dropped and stored in the Recycle BinB when a table is dropped and purged from the Recycle BinC  when you are required to recover an existing table to its previous stateD  when you are required to view all the versions of a row of an existing table between a specific time period

考题 单选题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 modeB  RESTRICTED modeC  OPEN modeD  NOMOUNT mode

考题 单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()A  until Thursday morningB  until that point in time when the database is openedC  until that point in time when the recovery is performedD  until last Sunday’s backupE  until that point in time when the table is dropped and purgedF  until Wednesday evening

考题 单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

考题 单选题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?()  RMANRUN  {   SET UNTIL SEQUENCE  THREAD ;   RESTORE DATABASE;   RECOVER DATABASE;  }A  NOMOUNTB  MOUNTC  OPEND  RESTRICTED

考题 单选题You are maintaining your database in ARCHIVELOG mode. An important table, SCOTT.EMPLOYEE, is dropped and purged from the Recycle Bin on Monday at 2:00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9:00 P.M. on Sunday.  How will you recover the dropped table, SCOTT.EMPLOYEE?()A  by using the Flashback Table featureB  by using the Flashback Database featureC  by performing incomplete recovery using RMAN utilityD  by performing incomplete recovery using user-managed recovery