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

What does CURRENTDATA option in bind indicate

IBM,

1 7326

What is the format (internal layout) of ?TIMESTAMP??

1 4257

What is the difference between group by and order by?

IBM, TCS,

2 12136

How many buffer pools are there in DB2?

2 5330

What are the three lock types?

2 4568

When is the access path determined for dynamic SQL?

2 6758

What is a Database Request Module(DBRM)?

4 16297

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

Tech Mahindra,

3 10224

What is cursor stability?

1 6999

What are data types?

2 3482

What is a NULL value? What are the pros and cons of using NULLS?

2 7111

What are leaf pages?

3 6217

when does the SQL statement gets executed when you use cursor in the application programming ?

IBM,

3 8122

What are the disadvantages of PAGE level lock?

3 5916

In terms of DB2 indexing, what is the root page?

1 3843


Post New DB2 Questions






Un-Answered Questions { DB2 }

Define check constraint.

214


How to execute stored procedure in db2 command editor?

152


What is the difference between oracle and db2?

165


What is the maximum length of sqlca?

273


What is consistency token in db2?

155






How do you select a row using indexes in db2?

175


Explain correlated sub-queries.

190


What is access path in db2?

162


Explain dclgen.

239


What is a plan and package in db2?

163


What is dclgen in db2?

171


What kind of database is db2?

156


What is alias in db2?

152


How will you return the number of records in table?

141


What are foreign keys in db2?

188