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

DB2 Interview Questions

Questions Answers Views Company eMail

What is a lock?

1 4961

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 5418

How does DB2 use multiple table indexes?

1 5809

What is meant by repeatable read?

4 10453

Compare a subselect to a join?

1 4974

Describe the elements of the SELECT query syntax?

3 6501

What is the command used by TSO users to invoke DB2?

IBM,

2 9409

What is the FREE command?

1 5176

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2840

What is DB2 (IBM Database 2)?

3 5661

What is QUIESCE?

2 13188

what is the name of the default db2 catalog database?

IBM,

3 8531

What are the three DB2 date and time data types and their associated functions?

1 5392

What is the significance of DB2 free space and what parameters control it?

1 5468

Explain the EXPLAIN statement?

1 4975

Post New DB2 Questions

Un-Answered Questions { DB2 }

Give a brief description of db2 isolation levels?

1068

List out the three types of page locks that can be held.

1147

Explain about dbrm.

1042

Explain about rct in db2?

1104

What is a trigger in the db2 database?

1072

Explain package in db2 and its advantages?

1212

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2091

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3202

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

1051

What is cobol db2?

996

What is the difference between dbm cfg and db cfg file in db2 ?

1531

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11673

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

4888

What does db2 stand for?

1023

Is db2 a programming language?

1046

For More Un-Answered { DB2 } Questions Click Here