ocp047的一道题

114. Which statements are true? (Choose all that apply.)

A. The data dictionary is created and maintained by the database

administrator.

B. The data dictionary views can consist of joins of dictionary base tables

and user defined tables.

C. The usernames of all the users including the database administrators are

stored in the data dictionary.

D. The USER_CONS_COLUMNS view should be queried to find the names of the

columns to which a constraint applies.

E. Both USER_OBJECTS and CAT views provide the same information about all

the objects that are owned by the user.

F. Views with the same name but different prefixes, such as DBA, ALL and USER,

use the same base tables from the data dictionary

Answer: CDF
解析：
A：数据字典是由oracle服务器创建和维护的一组只读的系统表。
B：数据字典视图总结了基础表的信息，无user defined tables.
C:正确
D：user_cons_columns用来查询有约束应用于列的列名。正确
E：USER_CATALOG和cat是一样的
F：dba,all只比user表 多了owner列，其他结构一致，内容随权限不同而不同，都是基于数据字典中一张基础表之上。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29674916/viewspace-1827663/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29674916/viewspace-1827663/