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

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

For More Un-Answered { DB2 } Questions Click Here