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 8940

What are some characteristics of columns that benefit from indexes?

1 4675

How will you delete duplicate records from a table?

Google,

7 25317

When is the skeleton cursor table created?

1 5163

What is cursor stability?

1 5564

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

IBM,

2 8573

Explain the use of the WHERE clause.

IBM,

2 5544

What is index cardinality?

3 11150

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

IBM, Tech Mahindra,

2 12230

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

1 4700

What is the meaning of -805 SQL return code?

3 12949

What is a base table?

2 4959

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

IBM,

2 6008

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

2 8957

What is the STOSPACE Utility used for?

1 6598

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you select a row using indexes in db2?

1172

Highlight all the advantages that are attached to a package.

1169

What are the two types of logging in the db2 database? Explain them.

1120

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2290

What is db2 look?

1073

List out the three types of page locks that can be held.

1191

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3002

What is db2 catalog database?

1087

How to get the ddl of a table in db2?

1168

How is a typical db2 batch pgm executed?

1221

What is the function of logging in the db2 database?

1172

How to find primary key of a table in db2?

1111

How many databases are there?

1106

Explain in detail about buffer manager and its functionalities?

1135

What is the physical storage length of date data type?

1304

For More Un-Answered { DB2 } Questions Click Here