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 7012

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

 1 4592

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

 2 8473

How many buffer pools are available in db2?

 2 6189

What is the size of a data page?

IBM,

2 4822

What is the difference between CS and RR isolation levels?

 1 7728

Name the different types of Table spaces.

IBM,

5 13540

How do you retrieve the data from a nullable column?

 2 7572

What is a clustering index ?

 3 6037

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

 1 6042

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 8071

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

 1 4514

What is a host variable?

 3 5647

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 9510

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

 1 4373

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the physical storage length of time data type?

666

How can deadlocks be resolved?

536

Explain about dbrm.

603

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

662

What does sqlcabc has?

625




When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3114

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

702

How does coalesce work?

581

What os does db2 run on?

570

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1572

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1708

What are the 2 sqlcodes that are returned?

633

How is the value function used?

600

How many databases are there?

588

what is the sqlcode -501

11277

For More Un-Answered { DB2 } Questions Click Here