Can one database have multiple instances?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are the various isolation levels possible?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is rebind in db2?
Explain in brief how does db2 determine what lock-size to use?
What is DB2 (IBM Database 2)?
Explain the contents that are a part of dclgen.
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is a clustered index?
What is the purpose of rollback and commit?
Mention the different locking levels that are available in db2.
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
How do you eliminate duplicate values in db2?