Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 3

Question : 19

Total: 40

Examine the commands executed in CDB$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 orc1123; 
 SQL> GRANT c##role1 TO c##admin CONTAINER=ALL; 
 SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER=ALL;

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

The command fails and gives an error because object privileges cannot be granted to a common user.
The command fails because container is not set to current.
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.
The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.
The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.

Validate

Go to Question:

Prev Question

Next Question