DB2 Interview Questions
Questions Answers Views Company eMail

How does DB2 determine what lock-size to use?

2 7823

What are some characteristics of columns that benefit from indexes?

1 3810

How will you delete duplicate records from a table?

Google,

7 22416

When is the skeleton cursor table created?

1 4341

What is cursor stability?

1 4683

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

IBM,

2 7033

Explain the use of the WHERE clause.

IBM,

2 4173

What is index cardinality?

3 9622

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

IBM, Tech Mahindra,

2 10372

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

1 3881

What is the meaning of -805 SQL return code?

3 11207

What is a base table?

2 3866

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

IBM,

2 4844

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

2 7513

What is the STOSPACE Utility used for?

1 5758


Post New DB2 Questions

Un-Answered Questions { DB2 }

Give the name of some fields form sqlca.

607


What is bind package and plan in db2?

586


What is phantom read in db2?

630


What is explain plan in db2?

580


How to create db2 table in mainframe?

621






What is alias in db2?

559


What is a system catalog table in db2?

576


How do I import data from excel to db2?

607


How do you select a row using indexes in db2?

633


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

678


How do I delete a column in db2?

669


What types of tables are there in the db2 database?

543


What is schema in db2?

570


What is coalesce in db2?

674


Discuss about db2 bind?

658