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

15. A role is a convenient way to group what? (Choose all that apply.)
A. Roles
B. Privileges
C. Users
D. Containers
16. A common role must abide by which of the following rules? (Choose all that apply.)
A. It must use the same naming convention as local users.
B. It must use the same naming convention as common users.
C. It can be created in any container in the CDB.
D. When granted, it applies to all containers in a CDB.
E. None of the above
17. As the DBA, you pride yourself in making the lives of your developers and end users
easier, so you think it's a good idea to grant CREATE ROLE to all users. Is this a good
idea? (Choose all that apply.)
A. This is a great idea, because now the security administrator will not have to worry
about who has access to what.
B. This is a bad idea because anyone can create any role, which could cause your
security administrator extra work to manage the roles and associated privileges.
C. This idea is neutral, because creating roles doesn't cause problems; it's the privileges
associated with the roles that can cause security issues.
D. All of the above.
E. None of the above
18. One of the nice features of roles is that you can grant a role to another role. Which of
the following is invalid? (Choose all that apply.)
A. Granting a local role to a common role
B. Granting role1 to role2 and role2 to role3
C. Granting role1 to role2 and role2 to role1
D. Granting a common role to a local role
E. None of the above