Question 131

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
  • Question 132

    Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)
  • Question 133

    You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container
    database (CDB).
    Examine the steps required to perform the migration:
    1. Use Data Pump export to perform a full transportable export on the source database with the export
    parameter VERSION=12.
    2. Place all tablespaces in read-only mode on the source database.
    3. Upgrade the source database to Oracle Database 12c.
    4. Copy the dump file and data files to the desired location in the target database.
    5. Create a new PDB in the target CDB.
    6. Synchronize the PDB on the target CDB.
    7. Use Data Pump import on the new PDB by using the full transportable import options.
    Identify the required steps in the correct order.
  • Question 134

    RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

    What is the outcome?
  • Question 135

    Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
    SQL> SELECT name, active_sessions, queue_length,
    consumed_cpu_time, cpu_waits, cpu_wait_time
    FROM v$rsrc_consumer_group;

    Which two statements are true?