Multiple choice

Which data dictionary view(s) are needed to query to find the following information about a user? Whether the user's account has expired The user's default tablespace name
The user's profile name

  1. DBA_USERS only

  2. DBA_USERS and DBA_PROFILES

  3. DBA_USERS and DBA_TABLESPACES

  4. DBA_USERS, DBA_TS_QUOTAS, and DBA_PROFILES
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DBA_USERS contains the ACCOUNT_STATUS column (shows expired/open), DEFAULT_TABLESPACE column, and a PROFILE column. All three required pieces of information are in this single view. DBA_PROFILES is not needed because the profile name (not profile details) is already in DBA_USERS. DBA_TABLESPaces is unnecessary for this query. DBA_TS_QUOTAs shows tablespace quotas, not required information.

Keep practicing — related questions