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

DB2 Interview Questions

Questions Answers Views Company eMail

Define sqlca.

1113

Explain packages.

1113

Mention the definition of cobol in varchar field.

1250

Explain the function done by data manager?

1280

Define buffer pool.

1056

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

1060

Explain in detail about buffer manager and its functionalities?

1066

Mention the various locks that are available in db2.

1039

Explain about dbrm.

1047

What does a deadlock mean in DB2?

1168

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

1178

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.

1109

Post New DB2 Questions

Un-Answered Questions { DB2 }

Describe major components of db2?

1093

Before you give the explain statement, what are the prerogatives?

1040

What is a bind card?

1217

Which are the db2 tools to protect integrity of the database?

1122

What is bind in db2?

1044

What is a plan and package in db2?

1104

How can you quickly find out the # of rows updated after an update statement?

1049

can all users have the privilage to use the sql statement select * (dml)?

1171

What are the bind parameters ibm db2?

1053

What is cursor in dbms?

1069

what is diffrence b/w file-aid tool and file-aid utility???

4892

What is a db2 schema?

1233

What does db2 plan contain?

1021

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

How do you stop a db2 database in linux?

1014

For More Un-Answered { DB2 } Questions Click Here