DB2 Interview Questions
Questions Answers Views Company eMail

When do you use the IMAGECOPY?

4 7255

What do you mean by NOT NULL? When will you use it?

3 5467

When would you prefer to use VARCHAR?

3 6566

Explain an outer join?

1 4584

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

IBM,

1 5294

What is REORG? When is it used?

4 8640

How are write I/Os from the buffer pool executed?

1 3522

What is the syntax of SELECT statement when embedded in a COBOL program?

2 9090

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 25176

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 3498

What are foreign keys?

1 4265

What is JOIN and different types of JOIN.

IBM,

2 11619

What does DSNDB07 database do?

2 11394

What is a DB2 access path?

1 6545

What is a recovery log?

1 4210


Post New DB2 Questions

Un-Answered Questions { DB2 }

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

664


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1896


Why select is not preferred in embedded sql programs?

815


What is sqlca?

701


What does db2 blu stand for?

757






Discuss about db2 bind?

747


How do I change the column size in db2?

709


How do I copy a table in db2?

664


What are the benefits of using the db2 database?

760


When the like statement is used?

725


Explain package in db2 and its advantages?

695


Why do we bind in db2?

736


What are db2 tables?

742


How and when does the db2 enforces the unique key?

721


How to access db2 tables in mainframe?

696