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.

题目

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

1.You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

2.Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）A、recovery cannot be performed because a backup was not performed after the last incomplete recoveryB、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

3. 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)

4. Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）A、 the datafiles associated with the SYSTEM tablespaceB、 the datafiles associated to the DATA1 tablespaceC、 the datafiles associated to the SYSTEM and DATA1 tablespacesD、 all the datafiles in the database

更多“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.”相关问题

  • 第1题：

    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.

    正确答案:C

  • 第2题：

    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

    • A、Open the database in NORMAL mode
    • B、Open the database in read-only mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:D

  • 第3题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第4题：

    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 recovery
    • B、 user managed incomplete recovery
    • C、 RMAN-based complete recovery
    • D、 RMAN-based incomplete recovery

    正确答案:D

  • 第5题：

    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

    正确答案:A

  • 第6题：

    单选题
    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：   SQL>ALTER DATABASE OPEN RESETLOGS；   What will be the resultant log sequence numbers？（）
    A

     0 and 1

    B

     1 and 2

    C

     1005 and 1006

    D

     1006 and 1007


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    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 recovery

    B

     user managed incomplete recovery

    C

     RMAN-based complete recovery

    D

     RMAN-based incomplete recovery


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    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 TSPITR

    B

     Move objects to another schema that has the same tablespace assigned

    C

     Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

    D

     Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）


    正确答案： A
    解析： 暂无解析

  • 第9题：

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


    正确答案： A
    解析： 暂无解析

  • 第10题：

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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
    A

     by using the Flashback Database feature

    B

     by using RMAN incomplete recovery

    C

     by performing a user-managed incomplete recovery

    D

     by dropping and re-creating the index tablespace


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）
    A

    recovery cannot be performed because a backup was not performed after the last incomplete recovery

    B

    restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

    C

    restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    D

    restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

    正确答案:A

  • 第14题：

    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

  • 第15题：

    You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

    • A、 incomplete recovery
    • B、 complete recovery
    • C、 recovery using the Flashback Database feature
    • D、 recovery using the export/import utility

    正确答案:A

  • 第16题：

    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

  • 第17题：

    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：   SQL>ALTER DATABASE OPEN RESETLOGS；   What will be the resultant log sequence numbers？（）

    • A、 0 and 1
    • B、 1 and 2
    • C、 1005 and 1006
    • D、 1006 and 1007

    正确答案:B

  • 第18题：

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


    正确答案： D
    解析： 暂无解析

  • 第19题：

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


    正确答案： A
    解析： 暂无解析

  • 第20题：

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


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）
    A

     the datafiles associated with the SYSTEM tablespace

    B

     the datafiles associated to the DATA1 tablespace

    C

     the datafiles associated to the SYSTEM and DATA1 tablespaces

    D

     all the datafiles in the database


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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 feature

    B

     by using the Flashback Database feature

    C

     by performing incomplete recovery using RMAN utility

    D

     by performing incomplete recovery using user-managed recovery


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

相关内容