Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 40 of 40

Marks: +1, -0

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb

\$

root as the sys user.
You execute the commands:


 SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; 
 SQL> CREATE ROLE C##CONNECT; 
 SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; 
 SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;

Which statement is true about the c##connect role?

It is created only in cdb $\$$ root and cannot be granted to the c##admin user with the container=all clause.
It is granted to the c##admin user only in the CDB.
It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.
It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Validate

Go to Question:

Prev Question