Question 91

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 92

    Which two statements are true regarding Oracle Data Pump? (Choose two.)
  • Question 93

    You created a tablespace with this statement:
    CREATE BIGFILE TABLESPACE adtbs
    DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
    The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
    Which two alter statements will achieve this? (Choose two.)
  • Question 94

    While performing database backup to tape via the media manager interface, you notice that tape
    streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
    Which two actions would you take for tape streaming to happen during the backup? (Choose two.)
  • Question 95

    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?