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.

1032

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

1127

What are the uses of db2 optimizer?

1295

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

1060

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

1036

What is the information associated with sysibm.syslinks table?

1123

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

1077

What is the purpose of using commit?

1098

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

1146

What is meant by explain?

1133

Define db2.

1113

Highlight all the advantages that are attached to a package.

1119

What is release/acquire in bind?

1103

Mention some fields that are a part of sqlca.

1033

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

1065

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the difference between cursor and select statement?

1101

What is the role of the data page in the db2 database?

1028

What is commit in db2?

1055

What is with ur in db2?

1316

What is cobol db2?

1000

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

1139

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2329

What is difference between isnull and coalesce?

1054

How do you pull up a query which was previously saved in qmf?

1149

What is the use of reorg in db2?

1084

What is database manager in db2?

1020

How to take backup of table in db2?

1074

How to execute stored procedures?

1130

List out the buffer pools in db2

1074

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

For More Un-Answered { DB2 } Questions Click Here