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

DB2 Interview Questions

Questions Answers Views Company eMail

Define sqlca.

1105

Explain packages.

1109

Mention the definition of cobol in varchar field.

1246

Explain the function done by data manager?

1276

Define buffer pool.

1050

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

1051

Explain in detail about buffer manager and its functionalities?

1063

Mention the various locks that are available in db2.

1035

Explain about dbrm.

1042

What does a deadlock mean in DB2?

1160

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

1169

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?

1074

Name the lockable units in DB2?

1126

What is check constraint. Explain with example.

1101

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

2153

Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8279

Give a brief description of db2 isolation levels?

1068

What are iseries servers?

1071

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

1651

When reorg is used?

1124

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2178

How do you eliminate duplicate values in db2?

1174

Explain correlated sub-queries.

1025

What is the clustering index in the db2 database?

1001

What is a system catalog table in db2?

1184

What is dbrm? What it contains?

1163

What do you mean by commit and rollback?

1035

What is the reason behind not using select * in embedded sql programs?

1111

How to execute stored procedures?

1130

For More Un-Answered { DB2 } Questions Click Here