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 20247

How does DB2 store NULL physically?

2 10827

Explain the use of the WHERE clause?

1 3991

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

CSI, CTS,

1 9389

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

1 4313

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

3 8287

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

2 8948

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

1 4655

What is an asychronous write?

1 4561

What is correlated subquery?

1 4882

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

1 3959

What is a precompiler?

2 5805

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

2 5516

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

2 6067

What will the COMMIT accomplish?

5 7631

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is cursor in dbms?

1008

Which component is responsible for processing sql statements and selecting access paths?

1074

Explain about rct.

1026

What is dbrm in db2 database?

1035

How do I create a view in db2?

976

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1093

What is explain in db2?

961

How do I add a column in db2?

1000

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

1050

Define db2 and its databases?

1006

What is dclgen in db2?

1084

What is dpf in db2?

1050

What is the difference between bind and rebind in db2?

1396

What parameters are used to control the free space in DB2?

1012

What is buffer pool in the db2 database?

1047

For More Un-Answered { DB2 } Questions Click Here