Multiple choice technology databases

SQL0901 error means?

  1. SQL System Error

  2. SQL Data base error

  3. SQL numeric error

  4. None of the these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL0901 is the DB2 SQL error code for 'SQL System Error' - a generic error indicating an unexpected system-level failure in the database engine. It's not a data-specific error (SQLCODE -204, -208 for object/column not found) or a numeric error - it's a catch-all for internal DB2 problems.

AI explanation

In DB2, SQLCODE -901 (SQL0901) is documented as "SQL SYSTEM ERROR" — it signals an unexpected internal failure in the database manager itself (not a data, syntax, or numeric-format problem), usually accompanied by a diagnostic log entry and requiring escalation to the DBA/support team since the application typically can't correct it. "SQL Data base error" and "SQL numeric error" are not real DB2 SQLCODE categories for -901, and since a specific correct category exists, "None of these" is wrong.

Keep practicing — related questions