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 8456

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

3 6536

When would you prefer to use VARCHAR?

3 7683

Explain an outer join?

1 5147

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

IBM,

1 5887

What is REORG? When is it used?

4 9979

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

1 4146

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

2 10086

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 26840

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

1 4053

What are foreign keys?

1 4846

What is JOIN and different types of JOIN.

IBM,

2 12571

What does DSNDB07 database do?

2 12214

What is a DB2 access path?

1 7168

What is a recovery log?

1 4804

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is iseries database?

1047

When the like statement is used?

1222

What is concurrency?

1233

How is the value function used?

1154

Mention some fields that are a part of sqlca.

1033

Explain various types of locks in db2?

1150

How to restart a DB2 program?

1902

What is the clustering index in the db2 database?

1001

How do I optimize a query in db2?

1101

What does sqlcabc has?

1054

What type of database is db2?

971

What is the syntax for seeing the columns and data types of a table in the db2 database?

1167

Explain how can you do the explain of a dynamic sql statement?

1125

How connect db2 database to datastage?

1242

What are types of indexes?

1072

For More Un-Answered { DB2 } Questions Click Here