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 6018

What is the database descriptor?

2 14460

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

1 9613

What is meant by AUTO COMMIT?

3 9989

What information is contained in a SYSCOPY entry?

2 9890

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

Emsang,

5 20322

What is lock contention?

1 5515

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 4416

What is COPY PENDING status?

6 36689

What is IMAGECOPY ?

6 39403

What are the functions of Bind?

Amdocs, IBM,

2 8406

What is a cursor?

2 6434

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

1 13613

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

2 5465

What can the Locate option of the Repair Utility accomplish?

2 5502

Post New DB2 Questions

Un-Answered Questions { DB2 }

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029

How to access db2 tables in mainframe?

990

What is ibm db2 client?

879

What is cursor in dbms?

1005

What is meant by union and union all?

948

What kind of database is db2?

974

What are the uses of db2 optimizer?

1223

Name the various locking levels available?

1035

How does cobol compile db2 program?

1005

What is view db2?

1004

What is catalog database in db2?

1099

What are the 2 sqlcodes that are returned?

1128

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1092

How is the value function used?

1080

Is db2 a programming language?

983

For More Un-Answered { DB2 } Questions Click Here