DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

Define sqlca.

1165

Explain packages.

1165

Mention the definition of cobol in varchar field.

1315

Explain the function done by data manager?

1329

Define buffer pool.

1098

Outputs of explain are with matchcols = 0. What does this signify?

1108

Explain in detail about buffer manager and its functionalities?

1135

Mention the various locks that are available in db2.

1080

Explain about dbrm.

1106

What does a deadlock mean in DB2?

1215

What is the advantage in De-normalizing tables in DB2?

1227

What parameters are used to control the free space in DB2?

1094

How can record locking be achieved in those DB2 versions which do not support it?

1122

Name the lockable units in DB2?

1184

What is check constraint. Explain with example.

1158

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 table?

1064

What do you mean by commit and rollback?

1087

Where can you declare a cursor in a cobol-db2 program?

1137

What is copy pending and check pending in db2?

1040

Is ibm db2 free?

1063

What is the use of runstats in db2?

1178

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1531

What is the connection string to connect to the DB2 Database ?

1171

What is null in db2?

1068

What is the use of db2?

1112

How do you pull up a query which was previously saved in qmf?

1202

What is check constraint in db2?

1163

What is bind plan?

1095

i want to maintain uniqueness on pdf without make lf??????????

2204

B37 abend during spufi?

1506

For More Un-Answered { DB2 } Questions Click Here