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

DB2 Interview Questions

Questions Answers Views Company eMail

Could anyone clearly explain the diference between sub query and correlated sub query?

3 6107

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 6518

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 4151

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 5981

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

IBM,

2 7085

what is cursor stability?

IBM,

2 6312

how do we solve soc 7 and soc4 ?

Tech Mahindra,

3 10742

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 5327

how to check the table is empty or not?

IBM,

3 11777

what is the difference between where clause and having clause

IBM,

2 8982

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

TCS,

6 11545

what is utility for parm lib

IBM,

2417

what is parm utility

IBM,

2 4850

what is load and unload in db2

IBM,

1 6039

how to copy the host variables from ps file into cobol program other than include statement

Syntel,

1 8024

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which is faster delete or truncate?

1175

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

1106

What is bind and rebind in db2?

1186

Explain about mirror activator disk mirroring?

1059

What is a bind in db2?

1100

what is the responsibility of the construction superintendent

2209

What is the purpose of using commit?

1148

What are the bind parameters ibm db2?

1097

What does db2 plan contain?

1080

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1211

What is bind package and plan in db2?

1101

What are the different types of base tables?

1157

Can you use max on a char column?

1139

Explain db2.

1083

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

11740

For More Un-Answered { DB2 } Questions Click Here