Oracle Database 12c Advance Adminstration1z0-063 Test 4

Question : 15 of 40

Marks: +1, -0

One of your container databases (CDBs) has five pluggable databases (PDBs).
COMMON_USER_PREFIX is C##.
These commands executed successfully while connected as SYS to CDB

\$

ROOT:

SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123; 
 SQL> CREATE ROLE c##role1 CONTAINER=ALL; 
 SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL; 
 SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL; 
 SQL> GRANT c##role1 to system CONTAINER=ALL;

Which three are true? (Choose three.)

The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.
The C##DBA_ADMIN user is a local user in CDB $\$$ ROOT and PDB $\$$ SEED.
The c##role1 role will always have the same privileges in all current and future PDBs.
The C##DBA_ADMIN user is a local user in CDB $\$$ ROOT.
SYSTEM is able to create views in any PDB as a result of being a DBA user.
SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.

Validate

Go to Question:

Prev Question

Next Question