Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

When Can you be sure that a query will return only one row?

IBM,

4 6256

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

 1 4219

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

 2 7891

How many buffer pools are available in db2?

 2 5654

What is the size of a data page?

IBM,

2 4318

What is the difference between CS and RR isolation levels?

 1 7216

Name the different types of Table spaces.

IBM,

5 12641

How do you retrieve the data from a nullable column?

 2 7016

What is a clustering index ?

 3 5484

Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

 1 5668

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

 2 7638

What else is there in the PLAN apart from the access path?

 1 4166

What is a host variable?

 3 5031

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

 1 9046

Once you create a view, where would information about the view be stored?

 1 3946

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is consistency token in db2?

419

What is a trigger in the db2 database?

431

List down the types of triggers in the db2 database?

427

Explain db2.

450

Explain various types of locks in db2?

468




What is check constraint in db2?

435

what is db2 restart?

1521

What does a deadlock mean in DB2?

466

What is runstats utility in db2?

392

What is cascading rollback?

452

How do I create a view in db2?

424

What are the bind parameters ibm db2?

453

Can we delete records from view?

415

Give the name of some fields form sqlca.

465

How do I add a column in db2?

439

For More Un-Answered { DB2 } Questions Click Here