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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Otto

Otto

user_cons_columns