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

DB2 Interview Questions

Questions Answers Views Company eMail

Define sqlca.

1056

Explain packages.

1058

Mention the definition of cobol in varchar field.

1185

Explain the function done by data manager?

1221

Define buffer pool.

1000

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

997

Explain in detail about buffer manager and its functionalities?

998

Mention the various locks that are available in db2.

978

Explain about dbrm.

991

What does a deadlock mean in DB2?

1101

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

1117

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

1012

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

1021

Name the lockable units in DB2?

1075

What is check constraint. Explain with example.

1047

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to find the number of rows in db2 tables?

1002

What is the difference between oracle and db2?

1034

How to restart a DB2 program?

1830

What is rct?

1172

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1978

What is copy pending status in db2?

1071

What is copy pending and check pending in db2?

955

How can we retrieve the total number of records in RPG & CLLE?

584

What type of database is db2?

915

What is bind plan?

983

Explain the contents that are a part of dclgen.

1038

How many databases can be created inside an instance in db2 ?

981

What is a bind in db2?

987

Name the lockable units in DB2?

1075

What is load utility in db2?

1132

For More Un-Answered { DB2 } Questions Click Here