DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 20398

How does DB2 store NULL physically?

2 10937

Explain the use of the WHERE clause?

1 4099

How can you quickly find out the number of rows updated after an update statement?

CSI, CTS,

1 9537

How could one combine a set of incremental image copies into a single copy?

1 4414

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 8428

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 9090

What is a composite index and how does it differ from a multiple index?

1 4747

What is an asychronous write?

1 4638

What is correlated subquery?

1 5011

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 4041

What is a precompiler?

2 5957

Where would you find information about the type of database authority held by the user?

2 5622

How do you do the EXPLAIN of a dynamic SQL statement?

2 6188

What will the COMMIT accomplish?

5 7840

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the reason behind not using select * in embedded sql programs?

1115

What is cursor in dbms?

1066

What is the difference between db2 and oracle?

1131

Is schema the same as database?

1057

What is rebind in db2?

1060

Is ibm db2 open source?

1075

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

Is db2 a mainframe?

1043

What db2 400?

1189

What is check constraint in db2?

1087

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

How to compare data between two tables in db2?

1088

How does cobol compile db2 program?

1057

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

1092

How to run db2 command in windows?

1193

For More Un-Answered { DB2 } Questions Click Here