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 5652

What is the database descriptor?

2 13746

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

1 9077

What is meant by AUTO COMMIT?

3 9402

What information is contained in a SYSCOPY entry?

2 9444

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

Emsang,

5 19619

What is lock contention?

1 5099

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 4104

What is COPY PENDING status?

6 35714

What is IMAGECOPY ?

6 38256

What are the functions of Bind?

Amdocs, IBM,

2 7713

What is a cursor?

2 5960

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

1 13068

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

2 4830

What can the Locate option of the Repair Utility accomplish?

2 5087


Post New DB2 Questions

Un-Answered Questions { DB2 }

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

814


Define db2 and its databases?

809


What are the benefits of using the db2 database?

875


What does reorg do in db2?

771


What is syscat in db2?

768


List some fields from sqlca?

797


What is db2 bind?

807


What is multi row fetch in db2?

765


What is database alias db2?

832


Explain various types of locks in db2?

877


What is collection in db2 bind?

765


What is check constraint in db2?

804


What is the meaning concurrency in the db2 database?

841


How to check last update on table in db2?

810


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 .....

2101