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

Where besides the DB2 catalog is database object information stored by DB2?

 1 4233

What is isolation level?

 4 5673

What is a predicate?

 1 3963

What is ALTER ?

 3 5606

What do you need to do before you do EXPLAIN?

 1 4430

How do you insert a record with a nullable column?

 2 5234

What is a result table?

 1 4420

What is the SQL Communications Area and what are some of its key fields?

 1 4023

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

 1 3589

How would one remove old reorg information from the DB2 catalog?

 2 5309

The only place of VSAM KSDS in DB2 is?

IBM,

2 6499

What is DCLGEN?

 2 14414

Where is the output of EXPLAIN stored?

 2 5688

What is the function of buffer manager?

 1 4909

What techniques are used to retrieve data from more than one table in a single SQL statement?

 2 5467

Post New DB2 Questions

Un-Answered Questions { DB2 }

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1644

What is dbrm in db2 database?

579

What is bind plan?

602

How to get the ddl of a table in db2?

668

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

616




What is a collection in db2?

573

Can you tell me how can you find out the # of rows updated after an update statement?

602

Which component is used to execute the sql statements?

609

What is the difference between db2 and oracle?

664

Why do we use cursor?

587

Are view updateable?

620

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10722

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

692

Why select is not preferred in embedded sql programs?

699

Is db2 a mainframe?

579

For More Un-Answered { DB2 } Questions Click Here