Explain package in db2 and its advantages?
No Answer is Posted For this Question
Be the First to Post Answer
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is a DB2 plan?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What are the levels of isolation available with DB2V4
What is an intent lock?
What is bind and rebind in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Which command is used to connect to a database in DB2 ? Give the Syntax.
Explain in detail about buffer manager and its functionalities?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
Can one database have multiple instances?
What is release/acquire in bind?