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 8280

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

3 6350

When would you prefer to use VARCHAR?

3 7519

Explain an outer join?

1 5034

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

IBM,

1 5793

What is REORG? When is it used?

4 9736

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

1 4028

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

2 9921

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 26613

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

1 3958

What are foreign keys?

1 4757

What is JOIN and different types of JOIN.

IBM,

2 12415

What does DSNDB07 database do?

2 12082

What is a DB2 access path?

1 7091

What is a recovery log?

1 4725

Post New DB2 Questions

Un-Answered Questions { DB2 }

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1034

Which isolation level provides highest data integrity?

1043

How do I add a column to a table in db2?

1051

What is the physical storage length of date data type?

1191

What are the full forms of spufi and dclgen and why are they used?

1025

What is data manager?

996

What is bind in db2?

979

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2007

What is isolation level in db2?

943

What is db2 command?

965

What are the benefits of using the db2 database?

1156

Is ibm db2 open source?

1016

What is page size in db2?

906

What is difference between alias and synonym in db2?

1072

What is sqlca?

1001

For More Un-Answered { DB2 } Questions Click Here