OCP-1Z0-051-2015-14题

QUESTION NO: 14
Which view should a user query to display the columns associated with the constraints on a table
owned by the user?
A. USER_CONSTRAINTS
B. USER_OBJECTS
C. ALL_CONSTRAINTS
D. USER_CONS_COLUMNS
E. USER_COLUMNS

Answer: D

Explanation: view the columns associated with the constraint names in the
USER_CONS_COLUMNS view.

user_cons_columns是表约束字段的视图,说明表中的和用户相关的列参与了哪些约束。这些约束有主键约束,外键约束,索引约束.
Incorrect answer:
A：table to view all constraints definition and names表和视图所有约束定义和名字
B：show all object name belong to user展示用户所有对象
C：does not display column associated不能展示列的联系
E：no such view没有这样视图