Online Access Free 11gocmu Exam Questions

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

When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

• A.INCLUDING DEPENDENCIES
• B.COMPACT
• C.None of the above
• D.INCLUDING DEPENDENCIES CASCADE
• E.CASCADE

You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)

• A.Its entries are specific to a single database.
• B.It contains file systems that have been mounted by Direct NFS.
• C.It contains file systems that have been mounted by the kernel NFS system.
• D.It is globally available to all Oracle 11g databases on the machine.

Which of the following statements is true regarding the VERSIONS BETWEEN clause?

• A.The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
• B.The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
• C.The VERSIONS BETWEEN clause may be used in DML statements.
• D.The VERSIONS BETWEEN clause may be used in DDL statements.

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

• A.The next time you connect RMAN to just the recovery catalog
• B.The next time you back up the database when you are also connected to the recovery catalog and the target database
• C.Connecting to the recovery catalog and issuing the resync all databases command
• D.The next time you are connected to the target database and the recovery catalog database and issue the resync command
• E.The next time you connect to the recovery catalog and the target database with RMAN