SQL DB2 Interview Questions

Q: How many databases can a DB2 system manage?

The correct answer is 65279 databases

Q: What does SPUFI stands for?

The correct answer is SQL Processor Using File Input

Q: What does a positive SQL code indicates?

The correct answer is Exception

Q: When you will face SQLCODE -803?

The correct answer is Duplicate Key on INSERT or UPDATE

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

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?

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

3. What does SPUFI stands for?

4. What does a positive SQL code indicates?

5. When you will face SQLCODE -803?

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit