Question 151

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
  • Question 152

    Which three statements are true about a job chain?
  • Question 153

    Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
    Examine the command executed to back up pdb2_1:
    RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
    Which statement is true about the execution of this command?
  • Question 154

    View the Exhibit showing steps to create a database resource manager plan.
    SQL>executedbms_resource_manager.create_pendingarea();
    PL/SQLproceduresuccessfully completed.
    3 QL>execdbms_resource_manager,create_consumergroup
    ( consumer_group=>'OLTP,,comment=>,onlineuser')
    PL/SQLproceduresuccessfullycompleted.
    SQL>execdbras_resource_raanager.create_plan
    ( plan=>'PRIU3ER3',comment=>'dssprio');
    SQL>exec
    Dbms_resource_manager.create_plan_directive
    ( plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comraent=>'onlinegrp'CPU_Pl=>60); PL/3QLproceduresuccessfullycompleted.
    After execting the steps in the exhibit you execute this procedure, which results in an error:
    SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
    What is the reason for the error?
  • Question 155

    Which three statements are true regarding the use of the Database Migration Assistant for Unicode
    (DMU)? (Choose three.)