SQL DB2 Interview Questions

SQL DB2 interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. How many databases can a DB2 system manage?

A. 1 database

B. 65279 databases

C. 10 databases

D. Unlimited

Correct Answer is : 65279 databases

2. How many clustering index we can have for a single table?

A. 15

B. 10

C. 1

D. No Limit

Correct Answer is : 15

3. What does SPUFI stands for?

A. SQL Processor Using File Input

B. Sequential Processor Using File Input

C. Structured Processor Using File Input

D. Standard Processor Using File Input

Correct Answer is : SQL Processor Using File Input

4. What does a positive SQL code indicates?

A. Exception

B. Failure

C. Success

D. None of these

Correct Answer is : Exception

5. When you will face SQLCODE -803?

A. No Rows found satisfying the SQL statement or End of Cursor

B. Object not defined in DB2

C. Program has not been binded to the Plan

D. Duplicate Key on INSERT or UPDATE

Correct Answer is : Duplicate Key on INSERT or UPDATE

SQL DB2 interview questions