071考試不僅是OCP11g的考試科目,同時也是OCP 12c的考試科目,所以關(guān)心071考題的同學(xué)有很多,對此我們專門收集整理了近期071考試的原題,并對這些考題進行講解,希望幫助廣大考生順利通過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 包含所有用戶能夠訪問的數(shù)據(jù)字典視圖,但是有些 dba 打頭的是普通用戶不能訪問的。有些人認為 A 是對的,但是說法有漏洞。
B. system 用戶是操作系統(tǒng)管理員,sys 才是數(shù)據(jù)庫管理員,數(shù)據(jù)字典的所有基表和視圖都屬于 sys 用戶。
C. v$為前綴的動態(tài)性能視圖要有 DBA 權(quán)限才能訪問。
)
-----------------------------------------------
OCP解析公開課時間:【每周五晚8點】
OCP解析公開課地址:https://ke.qq.com/course/326223
OCP解析群資料分享:1015267481 驗證:ocp
另外,除了OCP公開課,OCM題庫直播也同步進行中,OCM最新題庫大爆料-【每周四晚8點】,【微信群直播】,可以聯(lián)系咨詢老師進群參與