DB2 Interview Questions
Questions Answers Views Company eMail

What does CURRENTDATA option in bind indicate

IBM,

1 8163

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

1 4989

What is the difference between group by and order by?

IBM, TCS,

2 13415

How many buffer pools are there in DB2?

2 6407

What are the three lock types?

2 5529

When is the access path determined for dynamic SQL?

2 7931

What is a Database Request Module(DBRM)?

4 18510

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

Tech Mahindra,

3 12322

What is cursor stability?

1 7753

What are data types?

2 4341

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

2 8227

What are leaf pages?

3 7436

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

IBM,

3 9213

What are the disadvantages of PAGE level lock?

3 7112

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

1 4514


Post New DB2 Questions

Un-Answered Questions { DB2 }

Which isolation level provides highest data integrity?

590


Can we delete records from view?

555


How do you simulate the explain of an embedded sql statement in spufi/qmf?

630


What db2 400?

672


How do you stop a db2 database in linux?

564






What is the difference between spufi and qmf?

633


What is a db2 cursor?

618


What is a db2 schema?

760


What is a page in db2?

606


How do I copy a table in db2?

571


What is precompiler in db2?

583


Is db2 a database?

570


What is clone table?

590


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

702


Is ibm db2 open source?

580