Which two statements are true?

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 table and select any table privileges. You then execute the commands: SQL>
GRANTc##role1 TOcMadmin CONTAINER=ALL; SQL>CONNsys/oracle@HR_PDB
assysdba SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT; Which two
statements are true?

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 table and select any table privileges. You then execute the commands: SQL>
GRANTc##role1 TOcMadmin CONTAINER=ALL; SQL>CONNsys/oracle@HR_PDB
assysdba SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT; Which two
statements are true?

A.
C##admin can create and select any table, and grant the c##role1 role to users only in
the root container.

B.
B_admin can create and select any table in both the root container and kr_pdb.

C.
c##admin can create and select any table in the root container and all the PDBs.

D.
B_admin can create and select any table only in hr_pdb.

E.
The grant c=»role1 to b_admin command returns an error because container should be

set to ALL.



Leave a Reply 1

Your email address will not be published. Required fields are marked *