Question 86

T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?
  • Question 87

    Which two are true about the SQL Tuning Advisor?
  • Question 88

    Choose two. RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog?
  • Question 89

    Which three are true about Database Point-in-Time Recovery? (Choose three.)
  • Question 90

    You want to transport the UNIVERSITYtablespace from one database to another.
    The UNIVERSITYtablespace is currently open read/write.
    The source and destination platforms have the same endian format.
    Examine this list of steps:
    9. Make the UNIVERSITYtablespace read-only on the source system.
    10.Export the UNIVERSITYtablespace metadata using EXPDP.
    11.Create a cross-platform backup set from the UNIVERSITYtablespace on the source system, using an RMANcommand that includes the DATAPUMPclause.
    12.Copy the cross-platform backup sets to the destination system.
    13.Copy the Data Pump dump set from the source to the destination system.
    14.Restore the cross-platform backup set on the destination system using an RMANcommand that includes the DATAPUMPclause.
    15.Import the UNIVERSITYtablespace metadata using IMPDP.
    16.Make the UNIVERSITYtablespace read/write on the destination system.
    Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITYtablespace?