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
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_1045.htm#REFRN20045
USER_CONS_COLUMNS describes columns that are owned by the current user and that are specified in constraint definitions。
Explanation: view the columns associated with the constraint names in the USER_CONS_COLUMNS view.
Incorrect answer:
Atable to view all constraints definition and names
Bshow all object name belong to user
Cdoes not display column associated
Eno such view
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25