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 6882

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

3 5229

When would you prefer to use VARCHAR?

3 6341

Explain an outer join?

1 4460

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

IBM,

1 5135

What is REORG? When is it used?

4 8390

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

1 3400

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

2 8908

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 24464

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

1 3387

What are foreign keys?

1 4118

What is JOIN and different types of JOIN.

IBM,

2 11445

What does DSNDB07 database do?

2 11206

What is a DB2 access path?

1 6397

What is a recovery log?

1 4073

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to connect to db2 database from windows command line?

562

Which isolation level provides maximum concurrency?

666

What is a page in db2?

610

How to resolve deadlock issue

17971

What does db2 blu stand for?

660

What is the purpose of rollback and commit?

593

What is the physical storage length of timestamp data type?

644

What is nvl in db2?

624

What is the role of schema in the db2 database?

649

Which component is used to execute the sql statements?

619

What is the physical storage length of date data type?

728

What is sqlca?

621

What is buffer pool?

613

What are the contents of a dclmgen?

628

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

3118

For More Un-Answered { DB2 } Questions Click Here