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 6533

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 5886

What is REORG? When is it used?

4 9979

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

1 4144

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

2 10085

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 26836

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 12569

What does DSNDB07 database do?

2 12214

What is a DB2 access path?

1 7167

What is a recovery log?

1 4804

Post New DB2 Questions

Un-Answered Questions { DB2 }

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

Explain dclgen.

1199

Explain the function done by data manager?

1280

What is the role of data manager in the db2 database?

1107

Is db2 a mainframe database?

1000

Which isolation level provides maximum concurrency?

1152

When reorg is used?

1126

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

1149

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

Explain about mirror activator disk mirroring?

1008

What is an instance database?

1052

How is the value function used?

1154

Define predicate?

1131

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

1534

What is phantom read in db2?

1157

For More Un-Answered { DB2 } Questions Click Here