Multiple choice

User Smith created indexes on some tables owned by user John. The following needs to be displayed:

index names index types

Which data dictionary view(s) should be queried?

  1. DBA_INDEXES only

  2. DBA_IND_COLUMNS only

  3. DBA_INDEXES and DBA_USERS

  4. DBA_IND COLUMNS and DBA_USERS

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DBA_INDEXES is the data dictionary view that contains both index names (INDEX_NAME column) and index types (INDEX_TYPE or TYPE column). DBA_IND_COLUMNS only contains column-level information about indexes. DBA_USERS contains user information, not index details.