Multiple choice technology databases

Which of the following options would be queried to get the descriptions of all tablespaces?

  1. USER_TABLESPACES
  2. V$TABLESPACE

  3. DBA_TABLESPACE_GROUPS

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

DBA_TABLESPACES is the correct data dictionary view that contains descriptions of all tablespaces in the database. USER_TABLESPACES only shows tablespaces accessible to the current user, while V$TABLESPACE and DBA_TABLESPACE_GROUPS are not valid views for tablespace descriptions.

Keep practicing — related questions