Oracle Database 12c Advance Adminstration1z0-063 Test 4

Question : 34 of 40

Marks: +1, -0

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.)

C##ADMIN can create and select any table in HR_PD
B. B_ADMIN can create and select any table only in HR_PDB.
A local role can be granted to c##role1 in a PDB
C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
Role c##role1 will always have the same privileges in each PDB.
B_ADMIN can create and select any table in both the root container and HR_PDB.

Validate

Go to Question:

Prev Question

Next Question