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 7372

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

 1 4768

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

 2 8694

How many buffer pools are available in db2?

 2 6453

What is the size of a data page?

IBM,

2 5063

What is the difference between CS and RR isolation levels?

 1 7923

Name the different types of Table spaces.

IBM,

5 13995

How do you retrieve the data from a nullable column?

 2 7806

What is a clustering index ?

 3 6348

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

 1 6226

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 8335

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

 1 4673

What is a host variable?

 3 5907

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 9706

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

 1 4535

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is cascading rollback?

711

What is the result of open cursor statement?

713

What type of database is db2?

606

What is netezza database?

662

Where do you specify them?

770




What is the cobol picture clause of the db2 data types date, time, timestamp?

704

How do I optimize a query in db2?

710

How to check sequence on a table in db2?

689

What is rct?

844

What is the maximum size of a char data type in db2?

672

Which command is used to remove all rows from a table?

649

Define db2 and its databases?

708

What is bufferpool in db2?

664

What is db2 command?

669

What is db2 catalog database?

659

For More Un-Answered { DB2 } Questions Click Here