Test Index

Oracle Database 12c Advance Adminstration1z0-063 Test 4

Question : 15

Total: 40

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