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 20389

How does DB2 store NULL physically?

2 10933

Explain the use of the WHERE clause?

1 4095

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

CSI, CTS,

1 9533

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

1 4406

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

3 8425

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

2 9084

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

1 4742

What is an asychronous write?

1 4635

What is correlated subquery?

1 5009

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

1 4040

What is a precompiler?

2 5951

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

2 5617

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

2 6188

What will the COMMIT accomplish?

5 7827

Post New DB2 Questions

Un-Answered Questions { DB2 }

How does cobol compile db2 program?

1050

What kind of database is db2?

1031

On which levels locks can be applied?

1123

What is the physical storage length of timestamp data type?

1089

How would the varchar column remarks defined?

1086

What is buffer pool and list some of them?

1025

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1234

Define declaration generator (dclgen).

1111

What are db2 tables?

1121

What is cloudant database?

1094

What is concurrency?

1228

How does db2 sample database connect?

1024

What is netezza database?

1021

How can deadlocks be resolved?

930

Explain the benefits you can get from mainframe connect?

970

For More Un-Answered { DB2 } Questions Click Here