Oracle Security in CDBs and PDBs - OCP: Oracle Database 12c Administrator Certified Professional - page 657

10. Which of the following are permitted by local users with administrative privileges?
(Choose all that apply.)
A. They can create local users.
B. They can shut down the PDB.
C. They can alter the pluggable database.
D. They can alter another pluggable database.
E. None of the above
11. Which of the following are allowed by user privileges? (Choose all that apply.)
A. The authority to run a PL/SQL package
B. The authority to execute a particular type of SQL statement
C. The authority to access an object that belongs to another user
D. Granting to common or local users
E. All of the above
12. Giving good advice to your security administrator is your specialty, so you recommend
granting the SYSDBA privilege to all users. Is this a good idea?
A. This is a good idea because it will make the DBA's job easier.
B. This is a good idea because it will make the security administrator's life easier.
C. This is a bad idea because now every user can drop objects and delete the data-
base.
D. This is a bad idea because every user can now shut down your database.
E. None of the above
13. Which of the following are characteristics of commonly granted privileges? (Choose all
that apply.)
A. Commonly granted privileges apply to all existing and future PDBs.
B. System and object privileges can be commonly granted.
C. It's a good idea to grant common privileges to the PUBLIC role.
D. None of the above
14. Which of the following accurately describes a local privilege?
A. It can be used only in the container in which it was created.
B. Only local users can grant local privileges.
C. You can grant local privileges only to local users.
D. None of the above