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

DB2 Interview Questions

Questions Answers Views Company eMail

How does DB2 determine what lock-size to use?

2 8831

What are some characteristics of columns that benefit from indexes?

1 4599

How will you delete duplicate records from a table?

Google,

7 25058

When is the skeleton cursor table created?

1 5073

What is cursor stability?

1 5482

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

IBM,

2 8442

Explain the use of the WHERE clause.

IBM,

2 5439

What is index cardinality?

3 11007

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

IBM, Tech Mahindra,

2 12109

What are the three types of page locks that can be held?

1 4611

What is the meaning of -805 SQL return code?

3 12800

What is a base table?

2 4858

what's the best lock size that you could use when you create a tablespace?

IBM,

2 5918

How would you print the output of an SQL statement from SPUFI?

2 8834

What is the STOSPACE Utility used for?

1 6528

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to take backup of table in db2?

1071

How to execute stored procedures?

1130

How do I optimize a query in db2?

1095

What is db2 and what is the use of db2 optimizer?

1056

Which is faster delete or truncate?

1123

How does coalesce work?

1012

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2386

How do I create a view in db2?

1020

What is db2 bind?

1079

What is the meaning concurrency in the db2 database?

1108

How can we read records for specific member in CL? AND rpg?

694

When do you specify the isolation level?

1028

How do I add a column to a table in db2?

1102

What are the different types of base tables?

1089

What is rct?

1229

For More Un-Answered { DB2 } Questions Click Here