Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 4

Question : 40

Total: 40

One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123; 
 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 three are true? (Choose three.)

The C##CONNECT role can be granted different roles and privileges in each PD
B. C##ADMIN has the orcl123 password in all PDBs.
The C##CONNECT role is granted to the C##ADMIN user in all PDBs.
CREATE SESSION is granted to the C##ADMIN user in all PDBs.
The C##CONNECT role is a local role defined only in CDB$ROOT.

Validate

Go to Question:

Prev Question