11gocmu 무료 덤프문제 온라인 액세스

What is the proper procedure to recover a lost tempfile?

• A.Copy an existing tempfile from another database.
• B.Re-create the tempfile with the create tempfile command.
• C.Restore the backup copy of the tempfile from the backup media.
• D.Re-create the tempfile with the create tablespace command.
• E.Re-create the tempfile with the alter tablespace command.

Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)

• A.Job arguments
• B.Schedule objects
• C.Job classes
• D.Program arguments
• E.All of the above

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

• A.Take an immediate AWR snapshot.
• B.Decrease the window size for the baseline.
• C.Decrease the expiration time for the baseline.
• D.Compute the baseline statistics.

You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)

• A.SYSAUX
• B.SYSTEM
• C.TEMP
• D.This restore is not possible.
• E.USERS
• F.UNDO

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 Incomplete Recovery before TSPITR with the System Change Number (SCN)
• B.Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• C.Move objects to another schema that has the same tablespace assigned
• D.Perform Export before TSPITR and Import after TSPITR