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 8839

What are some characteristics of columns that benefit from indexes?

1 4609

How will you delete duplicate records from a table?

Google,

7 25071

When is the skeleton cursor table created?

1 5079

What is cursor stability?

1 5484

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

IBM,

2 8444

Explain the use of the WHERE clause.

IBM,

2 5443

What is index cardinality?

3 11019

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

IBM, Tech Mahindra,

2 12114

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

1 4613

What is the meaning of -805 SQL return code?

3 12804

What is a base table?

2 4865

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

IBM,

2 5923

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

2 8840

What is the STOSPACE Utility used for?

1 6532

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 instance?

1094

How is deadlock resolved?

1146

What does sqlcabc has?

1054

What is copy pending status in db2?

1127

What is phantom read in db2?

1157

What does db2 mean?

1017

What are the 2 sqlcodes that are returned?

1189

What are packages in db2?

1023

What is iseries database?

1046

List some fields from sqlca?

1058

Where do you specify them?

1279

What is cobol db2?

1000

Mention the location where the output received from explain statement is stored.

1127

Explain various types of locks in db2?

1150

What does db2 blu stand for?

1165

For More Un-Answered { DB2 } Questions Click Here