O
Oracle Database 12c: Advanced Administration
277 Questions
Question No. 1
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the 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##rolel TO c##admin CONTAINER=ALL;
SQL> CONN sys/oracle@HR_PDB as sysdba
SQL> GRANT c##rolel TO b_admin CONTAINER=CURRENT;
Which two statements are true? (Choose two.)
Choose all the correct options from the given list.
01 / 277