Question 81

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? (Choose two.)
  • Question 82

    In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
    You rename the undotbs undo tablespace:
    ALTER TABLESPACE undotbs RENAME TO undotbs_old;
    Which statement is true?
  • Question 83

    You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
    What is the outcome?
  • Question 84

    Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs).
    In PDB HR_PDB, common user C##ADMIN and local user B_ADMIN have only the CONNECT privilege.
    You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
    You then execute the commands:
    SQL> GRANT c##role1 TO c##admin CONTAINER=ALL>;
    SQL> CONN sys/oracle@HR_PDB as sysdba
    SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;
    Which three statements are true? (Choose three.)
  • Question 85

    Examine the backup requirement for your company:
    1) Every Sunday, a backup of all used data file blocks is performed.
    2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is
    performed.
    3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
    Which backup strategy satisfies the requirements?