近两年来,OCP的考试题库频率变化,不断的增加新考题,071考试就是其中一个,给很多考071的考生造成困扰,对此,我们专门整理了OCP考试里关于071考试的原题,并带上答案,分享给大家。
--------------------------------------------
071题库汇总-第68题、choose two:
Which two statements are true? (Choose two.)
A) DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.
B) The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.
C) All the dynamic performance views prefixed with v$ are accessible to all the database users.
D) The USER_OBJECTS view can provide information about the tables and views created by the user who queries the view.
E) The USER_SYNONYMS view can provide information about private synonyms.
Answer:DE
(解析:A 答案的意思是 dict 包含所有用户能够访问的数据字典视图,但是有些 dba 打头的是普通用户不能访问的。有些人认为 A 是对的,但是说法有漏洞。
B. system 用户是操作系统管理员,sys 才是数据库管理员,数据字典的所有基表和视图都属于 sys 用户。
C. v$为前缀的动态性能视图要有 DBA 权限才能访问。
)
-----------------------------------------------
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与