Multiple choice technology databases

Pick the odd one out

  1. PLAN_TABLE

  2. EMPLOYEE_MASTER

  3. DSN_STATEMNT_TABLE

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

SYSTABLES is a DB2 system catalog table that automatically stores metadata about all tables in the database. The others (PLAN_TABLE, EMPLOYEE_MASTER, DSN_STATEMNT_TABLE) are either user-created or auxiliary tables for specific purposes like explain plans.

Keep practicing — related questions