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
Explanation:
view the columns associated with the constraint names in the USER_CONS_COLUMNS view.
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
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 10-25