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 contains all index information including index names, types (NORMAL, BITMAP, FUNCTION-BASED, etc.), status, and other properties. DBA_IND_COLUMNS shows which columns comprise each index but doesn't contain the index type information. DBA_USERS contains user account information, not index metadata.

Keep practicing — related questions