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

DB2 Interview Questions

Questions Answers Views Company eMail

When do you use the IMAGECOPY?

4 8577

What do you mean by NOT NULL? When will you use it?

3 6665

When would you prefer to use VARCHAR?

3 7837

Explain an outer join?

1 5211

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

IBM,

1 5941

What is REORG? When is it used?

4 10116

How are write I/Os from the buffer pool executed?

1 4219

What is the syntax of SELECT statement when embedded in a COBOL program?

2 10176

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 27019

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 4111

What are foreign keys?

1 4931

What is JOIN and different types of JOIN.

IBM,

2 12653

What does DSNDB07 database do?

2 12316

What is a DB2 access path?

1 7234

What is a recovery log?

1 4875

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain various types of locks in db2?

1204

How would the varchar column remarks defined?

1127

What is consistency token in db2?

1191

What is buffer pool in the db2 database?

1152

What is a db2 schema?

1295

What is the physical storage length of date data type?

1304

Is db2 a database?

1024

What is runstats db2?

1073

Give the name of some fields form sqlca.

1142

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2410

Mention the various locks that are available in db2.

1079

Is it possible using max on a char column?

1189

How to retrieve rows from a db2 table in embedded sql?

1438

How does cobol compile db2 program?

1125

What are concurrency issues?

1169

For More Un-Answered { DB2 } Questions Click Here