Which view should a user query to display the columns associated with the constraints on a table owned by the user?

The correct answer is D. USER_CONS_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

Creating and Managing Schema Objects

Question

Options

AUSER_CONSTRAINTS
BUSER_OBJECTS
CALL_CONSTRAINTS
DUSER_CONS_COLUMNS
EUSER_COLUMNS

How the community answered

(59 responses)

A
10% (6)
B
2% (1)
C
7% (4)
D
78% (46)
E
3% (2)

Explanation

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

Topics

#data dictionary views#USER_CONS_COLUMNS#constraints#schema objects

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice