Multiple choice

The location of all the tables and indexes owned by one user has to be determined. Which DBA view should be looked into?

  1. DBA_TABLES

  2. DBA_INDEXES

  3. DBA_SEGMENTS

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

DBA_SEGMENTS is the correct view because it contains information about ALL segments allocated to a user, including both tables and indexes. Tables and indexes are both stored as segments in the database. DBA_TABLES and DBA_INDEXES would require querying two separate views and joining them. DBA_TABLESPACES shows tablespace information, not user-specific object locations. DBA_SEGMENTS provides a comprehensive view of all storage segments owned by a user.

Keep practicing — related questions