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 6541

When would you prefer to use VARCHAR?

3 7685

Explain an outer join?

1 5148

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

IBM,

1 5888

What is REORG? When is it used?

4 9982

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

1 4148

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

2 10088

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 26846

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

1 4053

What are foreign keys?

1 4847

What is JOIN and different types of JOIN.

IBM,

2 12574

What does DSNDB07 database do?

2 12216

What is a DB2 access path?

1 7171

What is a recovery log?

1 4805

Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by between and in? Is between inclusive of specified range values?

1092

What is sqlca?

1076

What are union and union all?

983

What are host variables in db2?

1072

what is utility for parm lib

2377

List down the data types in the db2 database.

1124

How connect db2 database to datastage?

1243

How to check table size in db2 sap?

1040

What is universal database?

1069

How can deadlocks be resolved?

937

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What is phantom read in db2?

1160

How to find the maximum value in a column in the db2 database?

1084

can we view the access paths created by dbrm ? how ? thx

7098

How to take backup of table in db2?

1075

For More Un-Answered { DB2 } Questions Click Here