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

DB2 Interview Questions

Questions Answers Views Company eMail

Define sqlca.

1108

Explain packages.

1112

Mention the definition of cobol in varchar field.

1250

Explain the function done by data manager?

1280

Define buffer pool.

1054

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

1057

Explain in detail about buffer manager and its functionalities?

1065

Mention the various locks that are available in db2.

1039

Explain about dbrm.

1047

What does a deadlock mean in DB2?

1167

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

1175

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

1056

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

1076

Name the lockable units in DB2?

1128

What is check constraint. Explain with example.

1107

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain db2.

1034

How does cobol compile db2 program?

1057

Explain about cursor stability?

1050

What is runstats utility in db2?

1019

What do you mean by storage group (stogroup)?

1041

What is the use of predicate?

1042

How to create backup table in db2?

1090

What is runstats and reorg in db2?

1304

What is the difference between cursor stability and repeatable read isolation levels?

1174

What is the difference between oracle and db2?

1108

What is scrollable cursor in db2?

1055

How does coalesce work?

1021

Define buffer pool.

1054

How do you stop a db2 database in linux?

1012

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104

For More Un-Answered { DB2 } Questions Click Here