代码改变世界

12c OCP考试专项 [1z0-071]-Q1:系统权限/对象权限/角色(2020.06.12)

2020-06-12 14:28  askscuti  阅读(273)  评论(0编辑  收藏  举报

which three are true about privileges?

A.A combination of object and system privileges can be granted to a role.
B.All type of schema object have associated object privileges.
C.Schema owners can grant object privileges on object in their schema to any other user or role.
D.Object privileges granted on a table automatically apply to all sysnonyms for that table.
E.Only users with the GRANT ANY PRIVILEGES privilege can grent and revoke system privileges from other users.
F.Only user with the DBA role can create roles.

Answer: CDE

Explanation:
A:可以将对象权限和系统权限组合授权给角色。错误,不能组合授权,但可以分别将系统权限和对象权限授权给同一个角色。
B:所有类型的模式对象都有关联的对象权限。错误,clusters, indexes, triggers, and database links 这些没有关联的对象权限。
F:只有DBA角色的用户才能创建角色。错误,普通用户只要有 create role 系统权限就可以创建角色。

提示:答案为个人理解和解答,难免有错,也欢迎大家及时指正。