OCP-1Z0-052-V8.02-128题

128. Note the points about data dictionary views and dynamic performance views:

1) These are stored in the SYSTEM tablespace.

2) These are the based on the virtual tables.

3) These are owned by the SYS user.

4) These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to

TRUE.

5) The V$FIXED_TABLE view can be queried to list the names of these views.

Which statements listed describe the data dictionary views?

A.1 and 3

B.2, 3, and 5

C.1, 2, and 3

D.2, 3, 4, and 5

Answer: A  

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12710613

1,3.他们都被存在system表空间以及owned是sys用户。

2.动态性能视图以基于数据库服务器内部的内存结构构建的虚拟表为基础。

4.启用数据字典保护使用 O7_DICTIONARY_ACCESSIBILTY参数设置为false，则阻止普通用户访问数据字典。

5.V$FIXED_TABLE只能查询动能性能视图所有的名称。