Which statement is true about granting the select privi…

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##admin 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##ROLE1 role?

A.
The command fails and gives an error because object privileges cannot be granted to a common user.

B.
The command fails because CONTAINER is not set to CURRENT.

C.
The command succeeds and the common user c##ADMIN can create a session and query the DBA_USERS view in CDB$ROOT and all the PDBs.

D.
The command succeeds and the common user c##ADMIN can create a session in CDB
$ROOTand all the PDBs, but can only query the DBA_USERS view in CDB$ROOT.

E.
The command succeeds and the common user c##ADMIN can create a session and query the DBA_USERS view only in CDB$ROOT.