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

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