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 8845

What are some characteristics of columns that benefit from indexes?

1 4609

How will you delete duplicate records from a table?

Google,

7 25074

When is the skeleton cursor table created?

1 5083

What is cursor stability?

1 5486

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

IBM,

2 8446

Explain the use of the WHERE clause.

IBM,

2 5446

What is index cardinality?

3 11024

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

IBM, Tech Mahindra,

2 12119

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

1 4613

What is the meaning of -805 SQL return code?

3 12810

What is a base table?

2 4867

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

IBM,

2 5928

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

2 8841

What is the STOSPACE Utility used for?

1 6532

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is access path in db2?

986

What is reorg?

1161

How do I delete a table in db2?

1073

What is sqlca’s maximum length?

1189

How to check last update on table in db2?

1059

What is the use of db2 optimizer?

1117

What is buffer pool and list some of them?

1028

What is ibm db2 client?

939

How do I connect my db2 database to ibm?

1051

List some fields from sqlca?

1058

What is explain in db2?

1020

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

How to connect to db2 database from windows command line?

1066

What is lock escalation in db2?

1033

what are bind concepts in db2 cobol?

1092

For More Un-Answered { DB2 } Questions Click Here