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

What is a DBRM, PLAN ?

 3 17079

What's the maximum number of characters that a tablename can have?

 3 7613

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

CTS, IBM, TCS,

9 12885

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

 1 4191

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

 1643

Why use RUNSTAT Utility?

Merrill Lynch,

3 22533

What is auditing?

 2 4105

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

 2 4214

When do you specify the isolation level? How?

 1 4277

What do the initials DDL and DML stand for and what is their meaning?

 2 4393

What is the error code -803 ?

 3 10487

What can the SET option of the Repair Utility accomplish?

 1 4755

What are the levels of isolation available with DB2V4

IBM,

2 3715

Where are plans stored?

 2 6150

What is a clustering index?

 2 4484

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a storage group (stogroup)?

772

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

704

What db2 400?

672

What is the usage of open cursor command?

599

How would you find out the total number of rows in a db2 table?

572




How can deadlocks be resolved?

535

What is the maximum size of varchar data type in db2?

643

What is a bind card?

679

Why do we bind in db2?

625

Mention the location where the output received from explain statement is stored.

628

What is bufferpool in db2?

574

Is db2 a mainframe database?

561

Give a brief description of db2 isolation levels?

599

How do you eliminate duplicate values in db2?

679

What are the prerogatives?

612

For More Un-Answered { DB2 } Questions Click Here