Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions
Questions Answers Views Company eMail

How does DB2 determine what lock-size to use?

2 6671

What are some characteristics of columns that benefit from indexes?

1 2996

How will you delete duplicate records from a table?

Google,

7 19239

When is the skeleton cursor table created?

1 3596

What is cursor stability?

1 3788

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

IBM,

2 5662

Explain the use of the WHERE clause.

IBM,

2 3092

What is index cardinality?

3 8207

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

IBM, Tech Mahindra,

2 8511

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

1 3146

What is the meaning of -805 SQL return code?

3 9527

What is a base table?

2 2724

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

IBM,

2 3755

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

2 6093

What is the STOSPACE Utility used for?

1 4804


Post New DB2 Questions






Un-Answered Questions { DB2 }

What is the use of db2?

127


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2279


What is the syntax for creating a table in the db2 database?

182


What is db2 purescale?

128


What are the uses of db2 optimizer?

234






What are types of indexes?

142


Mention the downsides of page level lock.

183


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

175


What does db2 mean?

140


How do I import a csv file into db2?

122


Mention some fields that are a part of sqlca.

165


What is alias in db2?

121


What is performance tuning db2?

114


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

141


What do you mean by commit and rollback?

119