DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 6118

What is the database descriptor?

2 14668

What is the syntax required for the creation of a cursor?

1 9770

What is meant by AUTO COMMIT?

3 10167

What information is contained in a SYSCOPY entry?

2 10013

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

Emsang,

5 20553

What is lock contention?

1 5636

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 4506

What is COPY PENDING status?

6 37004

What is IMAGECOPY ?

6 39701

What are the functions of Bind?

Amdocs, IBM,

2 8582

What is a cursor?

2 6558

When is the authorization check on DB2 objects done - at BIND time or run time?

1 13739

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 5602

What can the Locate option of the Repair Utility accomplish?

2 5643

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to take backup of table in db2?

1075

How to fetch the last row from the table in SQL (db2)?

1655

How to find the number of rows in a db2 table?

1120

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 ?

2180

How do I optimize a query in db2?

1101

On which levels locks can be applied?

1133

What is the difference between oracle and db2?

1109

Mention the various locks that are available in db2.

1039

What kind of database is db2?

1036

What is rct?

1235

What do you mean by rollback?

991

How to connect to db2 database from windows command line?

1066

What is buffer pool and list some of them?

1028

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

1092

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2365

For More Un-Answered { DB2 } Questions Click Here