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

What is a DBRM, PLAN ?

 3 16400

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

 3 7064

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

CTS, IBM, TCS,

9 11695

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 3796

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?

 1497

Why use RUNSTAT Utility?

Merrill Lynch,

3 21945

What is auditing?

 2 3752

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

 2 3814

When do you specify the isolation level? How?

 1 3973

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

 2 3941

What is the error code -803 ?

 3 9969

What can the SET option of the Repair Utility accomplish?

 1 4445

What are the levels of isolation available with DB2V4

IBM,

2 3346

Where are plans stored?

 2 5571

What is a clustering index?

 2 4091

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can we read records for specific member in CL? AND rpg?

45

Explain about rct.

477

Can we update view in db2?

404

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

509

What is a bind card?

477




What is the use of db2 optimizer?

457

Is db2 a mainframe?

436

What is a plan and package in db2?

442

How many databases can be created inside an instance in db2 ?

443

What is syscat in db2?

400

What is the use of with ur in db2?

446

What are the contents of a dclmgen?

468

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

423

What does db2 plan contain?

431

What is the difference between cursor and select statement?

433

For More Un-Answered { DB2 } Questions Click Here