Question 31
In which three situations must you use a recovery catalog? (Choose three.)
Question 32
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
Question 33
Your database is running in ARCHIVELOGmode. Examine the initialization parameters you plan to set for
your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.
your database instance.
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'
LOG_ARCHIVE_DEST_2 = 'L0CATI0N=/disk2/3rch'
LOG_ARCHIVE_DEST_3 = 'LOCATION=/disk3/arch'
L0G_ARCHIVE_DEST_4 = 'L0CATI0N=/disk4/3rch MANDATORY'
Identify the statement that correctly describes these settings.
Question 34
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)
Question 35
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?
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?