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

相关问题推荐

• Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

  A、flash back the corrupted blocks

  B、use the DBMS_REPAIR package

  C、use the RMAN TSPITR command

  D、use the RMAN BLOCKRECOVER command

  E、use the RESTORE DATABASE and RECOVER DATABASE commands

  F、investigate the time at which the corruption occurred and perform a point-in-time recovery

  查看答案

• You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）;  Which statement is true？（）

  A、When a file is created in DGROUP1 with the template， it would have three­way mirroring. 

  B、When a file is created in DGROUP1， the MY_TEMP template becomes the default template.

  C、When a file is created in DGROUP1 with the template， it would have two­way mirroring and file striping.

  D、When a file is created in DGROUP1 with the template， it would have three­way mirroring and file striping.

  E、When a file is created in DGROUP1 with the template， it would have two­way mirroring but no file striping.

  查看答案

• Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily.  How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）

  A、by having each user run the report generation procedure at the scheduled time， supplying the necessary input variables

  B、by creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB

  C、by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report

  D、by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report

  E、by creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER

  查看答案

• Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）

  A

   Drop and re-create the inbox.

  B

   Coalesce the ORDERS_IND index.

  C

   Coalesce the INDEXES tablespace.

  D

   Drop and re-create the ORDERS table.

  E

   Rebuild the index online and move it to another tablespace.

  查看答案

• In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.  You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.  How do you achieve this objective？（）

  A、by setting the SQL_TRACE parameter to FALSE in the parameter file

  B、by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session

  C、by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session

  D、by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

  查看答案