1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What is Declaration Generator(DCLGEN)?

 1 6225

What is the difference between static and dynamic SQL?

 1 24961

How many Buffer pools are there in DB2 and what are they?

IBM,

1 6803

What is RUNSTATS?

 3 6388

How many sub queries can you combine together ?

IBM,

4 8481

What is a cursor and what is its function?

 2 4462

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

 1 4204

What does the sqlcode of -818 pertain to?

 3 6317

How many clustering indexes can be defined for a table?

 2 5925

What is tablespace?

 3 5132

What is the function of the Data Manager?

 2 4102

What is a SELECT statement?

 1 3582

How do you define a correlated name?

 1 3278

What is the self-referencing constraint?

 2 5316

What is a buffer pool?

 2 5473

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is difference between alias and synonym in db2?

633

What is a system catalog table in db2?

576

What is a db2 tablespace?

591

Why db2 is called db2?

587

How to fetch the last row from the table in SQL (db2)?

1025




What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

692

What is a page in db2?

602

What is check constraint. Explain with example.

637

List out the buffer pools in db2

616

Define db2.

658

Why cursor is used in db2?

565

What is sqlca’s maximum length?

662

Give the name of some fields form sqlca.

607

What is the use of value function?

612

What is cursor with hold option in db2?

601

For More Un-Answered { DB2 } Questions Click Here