Home » Oracle » 1z0-061 » Which view should a user query to display the columns associated with the constraints on a table owned by the user?
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
Correct Answer: D
Explanation/Reference:
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
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
