1Z1-060 Exam Question 36

You performed an incremental level 0 backup of a database:
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
'/mydir/rman_change_track.f';
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)
  • 1Z1-060 Exam Question 37

    Examine the parameter for your database instance:

    You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

    Identify the reason why the optimizer chose different execution plans.
  • 1Z1-060 Exam Question 38

    Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?
  • 1Z1-060 Exam Question 39

    You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
    The characteristics of the non-CDB are as follows:
    -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit
    The characteristics of the CDB are as follows:
    -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit
    Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
  • 1Z1-060 Exam Question 40

    Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
    The steps to recover the tablespace are as follows:
    1.Mount the CDB.
    2.Close all the PDBs.
    3.Open the database.
    4.Apply the archive redo logs.
    5.Restore the data file.
    6.Take the SYSAUX tablespace offline.
    7.Place the SYSAUX tablespace online.
    8.Open all the PDBs with RESETLOGS.
    9.Open the database with RESETLOGS.
    10.
    Execute the command SHUTDOWN ABORT.
    Which option identifies the correct sequence to recover the SYSAUX tablespace?