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

DB2 Interview Questions

Questions Answers Views Company eMail

Explain correlated sub-queries.

981

Mention the location where the output received from explain statement is stored.

1056

What are the uses of db2 optimizer?

1233

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1009

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

973

What is the information associated with sysibm.syslinks table?

1059

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1020

What is the purpose of using commit?

1042

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1099

What is meant by explain?

1068

Define db2.

1067

Highlight all the advantages that are attached to a package.

1076

What is release/acquire in bind?

1061

Mention some fields that are a part of sqlca.

974

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1009

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you stop a db2 database in linux?

962

What is db2 connect?

1015

What is difference between rollback and commit?

1096

What is a system catalog table in db2?

1108

How to get the ddl of a table in db2?

1074

What is the function of logging in the db2 database?

1071

What is an instance database?

1008

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

1021

what is the sqlcode -501

12934

What is reorg and runstats in db2?

1150

What are the bind parameters ibm db2?

992

What is temporal table in db2?

992

What is package in db2 mainframe?

924

What is null in db2?

950

Comment whether the cursor is closed during commit or not.

1043

For More Un-Answered { DB2 } Questions Click Here