Multiple choice technology mainframe

Match the below SQL CODE (1,2,3,4,5) Cause (A,B,C,D,E) 1)904 A)The string representation of a date time value is not a valid 2)818 B) Resource unavailable 3)181 C)Duplicate key on insert or update 4)803 D)Deadlock or timeout. Rollback has been done 5)911 E)Plan and program: timestamp mismatch

  1. A. 1B, 2E, 3A, 4C, 5D

  2. B. 1D, 2A, 3E, 4C, 5B

  3. C. 1E, 2D, 3B, 4A, 5C

  4. D. 1C, 2D, 3E, 4A, 5B
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DB2 SQL, -904 indicates a resource unavailable error, -818 represents a timestamp mismatch between plan and program, -181 indicates an invalid datetime format, -803 represents a duplicate key violation, and -911 indicates a deadlock or timeout. Option A matches all codes correctly.

Keep practicing — related questions