OCP题求解答

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 consists 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

 

翻译：

哪一个是正确的

A、数据字典的创建和维护是由DBA完成    （WRONG  是由ORACLE服务器创建和维护属于SYS用户）

B、数据字典视图：consists of 1、数据字典基础表和用户定义表

C、所有的用户名包括DBA都存于数据字典中  （TRUE）

D、找到应用约束的列的名称的话应该查询 USER_CONS_COLUMNS （TRUE）

SYS@ prod>desc USER_CONS_COLUMNS;
 名称                                                                                                                                                                        是否为空? 类型
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------
 OWNER                                                                                                                                                                         NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME                                                                                                                                                               NOT NULL VARCHAR2(30)
 TABLE_NAME                                                                                                                                                                    NOT NULL VARCHAR2(30)
 COLUMN_NAME                                                                                                                                                                            VARCHAR2(4000)
 POSITION                                                                                                                                                                               NUMBER

SYS@ prod>

E、USER_OBJECTS和CAT视图都提供了用户拥有的所有对象的相同信息。

F、名称相同但前缀不同的视图(如DBA、ALL和USER)使用数据字典中相同的基表

 

 

其他选项有人帮忙看一下吗？欢迎留言