Multiple choice technology databases

Identify the prefix of data dictionary views. Choose all that apply.

  1. ALL_

  2. USER_

  3. ORACLE_

  4. DBA_

  5. SCHEMA_

Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

Oracle data dictionary views have three standard prefixes: USER_ (objects owned by current user), ALL_ (objects accessible to current user), and DBA_ (all objects in database - requires DBA privilege). ORACLE_ and SCHEMA_ are not valid prefixes for data dictionary views.