nerdexam
Oracle

1Z0-061 · Question #91

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. View the columns associated with the constraint names in the USER_CONS_COLUMNS view.

Managing Objects with Data Dictionary Views

Question

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

Options

  • AUSER_CONSTRAINTS
  • BUSER_OBJECTS
  • CALL_CONSTRAINTS
  • DUSER_CONS_COLUMNS
  • EUSER_COLUMNS

How the community answered

(53 responses)
  • A
    8% (4)
  • B
    2% (1)
  • C
    11% (6)
  • D
    77% (41)
  • E
    2% (1)

Explanation

View the columns associated with the constraint names in the USER_CONS_COLUMNS view.

Topics

#USER_CONS_COLUMNS#data dictionary views#constraint columns#schema views

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice