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 8447

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

3 6528

When would you prefer to use VARCHAR?

3 7675

Explain an outer join?

1 5140

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 9969

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

1 4140

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

2 10079

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 26829

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

1 4049

What are foreign keys?

1 4843

What is JOIN and different types of JOIN.

IBM,

2 12562

What does DSNDB07 database do?

2 12204

What is a DB2 access path?

1 7163

What is a recovery log?

1 4802

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of value function?

1147

How to create db2 table in mainframe?

1154

what is db2 restart?

2149

Which component is used to execute the sql statements?

1094

What is host variable in db2 cobol?

1077

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

What is db2? Explain.

1041

What is node in db2?

1042

What is the use of dclgen in db2?

1083

What is buffer pool in the db2 database?

1091

How do you stop a db2 database in linux?

1010

How do I change the column size in db2?

1151

What are the prerogatives?

1078

What is release/acquire in bind?

1102

Define sqlca.

1105

For More Un-Answered { DB2 } Questions Click Here