免费试学 报名即可领取免费资料

成都市庆云南街69号红星国际3栋3楼

您现在的位置: IT培训 > OCP > 师资力量 > 正文

OCP 1Z0-047 考试题库解析(6)

发布时间:2018-08-08 16:01:25

  Which two statements are true? (Choose two.)

  A. The USER_SYNONYMS view can provide information about private synonyms.

  B. The user SYSTEM owns all the base tables and useraccessible 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.

  E. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

  答案: AE

  分析: 本题考点是数据字典/data dictionary

  B. system用户是操作系统管理员,sys才是数据库管理员,数据字典的所有基表和视图都属于sys用户。

  C. v$为前缀的动态性能视图要有DBA权限才能访问。

  D. USER_OBJECTS视图不仅包含用户的表、视图信息,还包括了其他对象如触发器、索引、过程等等。

 

免费试学

在下方预约即可免费领取视频学习资料