Multiple choice technology databases

Which of the following dictionary views gives information about the position of a column in a primary key?

  1. ALL_PRIMARY_KEYS

  2. ALL_TABLES

  3. ALL_IND_COLUMNS

  4. USER_CONSTRAINTS
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ALL_IND_COLUMNS provides information about index columns, including their position within the index. Since primary keys are implemented using indexes in Oracle, this view shows column positions within primary keys. Option A doesn't exist, option B shows table metadata, and option D shows constraint info but not column positions.

Keep practicing — related questions