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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
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

For More Un-Answered { DB2 } Questions Click Here