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 8703

What are some characteristics of columns that benefit from indexes?

1 4511

How will you delete duplicate records from a table?

Google,

7 24804

When is the skeleton cursor table created?

1 4990

What is cursor stability?

1 5409

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

IBM,

2 8288

Explain the use of the WHERE clause.

IBM,

2 5304

What is index cardinality?

3 10840

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

IBM, Tech Mahindra,

2 11960

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

1 4512

What is the meaning of -805 SQL return code?

3 12647

What is a base table?

2 4733

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

IBM,

2 5814

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

2 8699

What is the STOSPACE Utility used for?

1 6460

Post New DB2 Questions

Un-Answered Questions { DB2 }

What happens in bind step in a db2 program?

916

can we view the access paths created by dbrm ? how ? thx

6980

What is meant by union and union all?

949

What is the usage of open cursor command?

1040

What is host variable in db2 cobol?

1032

What is cobol db2?

935

How do I add a column in db2?

1000

What is dclgen (declaration generator)?

1012

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

1051

What is performance tuning db2?

1010

What is the use of runstats in db2?

1024

What is host variable?

1016

Explain the contents that are a part of dclgen.

1038

What is explain plan in db2?

944

What is the cobol picture clause of the db2 data types date, time, timestamp?

1012

For More Un-Answered { DB2 } Questions Click Here