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

DB2 Interview Questions

Questions Answers Views Company eMail

Can you tell me how can you find out the # of rows updated after an update statement?

1047

What are the contents of dclgen?

1054

Why select is not preferred in embedded sql programs?

1232

How do you select a row using indexes in db2?

1075

When reorg is used?

1073

What are the various isolation levels possible?

1051

How can you do the explain of a dynamic sql statement?

1018

Can you use max on a char column?

1031

List some fields from sqlca?

1004

Explain what are the various isolation levels possible?

991

What is the physical storage length of the data types date, time, and timestamp?

1042

What is the use of value function?

1076

If I have a view which is a join of two or more tables, can this view be updateable?

1086

What is the result of open cursor statement?

1030

How would the varchar column remarks defined?

1038

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is an instance in db2?

987

What is dbrm in db2 database?

1035

Explain package in db2 and its advantages?

1139

How to find the number of rows in db2 tables?

999

Explain about rct.

1026

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

993

What type of database is db2?

913

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

1012

What is the information associated with sysibm.syslinks table?

1058

What is the use of runstats in db2?

1024

Explain the function done by data manager?

1220

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

4812

What are the two types of logging in the db2 database? Explain them.

1019

What is the use of reorg in db2?

1027

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

1117

For More Un-Answered { DB2 } Questions Click Here