⟩ Explain the Hierarchical Database?
► Follows inverted tree structure
► Data relationship is predefined by it's structure
► Program accesses the data through predefined paths.
► Follows inverted tree structure
► Data relationship is predefined by it's structure
► Program accesses the data through predefined paths.
Can GROUP BY and ORDERED BY used in a single query?
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
When DB2 connection fails, will online program work or give errors?
Can you have more than one cursor open at any one time in a program ?
How does DB2 determine what lock-size to use?
What is a composite index and how does it differ from a multiple index?
What are delete-connected tables?
What are the disadvantages of PAGE level lock?
What is a precompiler?
What is the diff bet plan,package,dbrm?