1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

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

 3 19419

How does DB2 store NULL physically?

 2 10209

Explain the use of the WHERE clause?

 1 3385

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

CSI, CTS,

1 8767

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

 1 3695

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

 3 7455

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

 2 8293

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

 1 4002

What is an asychronous write?

 1 4067

What is correlated subquery?

 1 4276

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

 1 3517

What is a precompiler?

 2 4880

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

 2 4935

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

 2 5345

What will the COMMIT accomplish?

 5 6676

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which component is responsible for db2 startup and shutdown?

710

How do we specify index to include or not during bind process.

1764

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

820

Define db2 and its databases?

708

Differentiate between cs and rr isolation levels? Where do you specify them?

671




Explain in brief how does db2 determine what lock-size to use?

673

What does runstats do in db2?

689

What are the different types of base tables?

657

What is the advantage in De-normalizing tables in DB2?

837

Can you use max on a char column?

717

What are foreign keys in db2?

703

What is the physical storage length of timestamp data type?

739

What is bind package and plan in db2?

694

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

768

What is the purpose of rollback and commit?

677

For More Un-Answered { DB2 } Questions Click Here