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 is a lock?

1 3982

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 3943

How does DB2 use multiple table indexes?

1 4671

What is meant by repeatable read?

4 8209

Compare a subselect to a join?

1 3752

Describe the elements of the SELECT query syntax?

3 4614

What is the command used by TSO users to invoke DB2?

IBM,

2 7985

What is the FREE command?

1 3990

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2099

What is DB2 (IBM Database 2)?

3 3825

What is QUIESCE?

2 11691

what is the name of the default db2 catalog database?

IBM,

3 6748

What are the three DB2 date and time data types and their associated functions?

1 4308

What is the significance of DB2 free space and what parameters control it?

1 4367

Explain the EXPLAIN statement?

1 3900


Post New DB2 Questions

Un-Answered Questions { DB2 }

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

5871


Mention the definition of cobol in varchar field.

505


What is an instance database?

436


What are host variables in db2?

421


What is isolation level in db2?

404






What is commit in db2?

431


What is the physical storage length of timestamp data type?

460


Mention the location where the output received from explain statement is stored.

475


How can the duplicate values be eliminated from db2 select?

475


Mention the various locks that are available in db2.

474


How do I import a csv file into db2?

415


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2154


What is the connection string to connect to the DB2 Database ?

465


Outputs of explain are with matchcols = 0. What does this signify?

473


What is table space in db2?

430