What is the difference between IN subselects and EXISTS
subselect?
Answer / s
IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.
Is This Answer Correct ? | 11 Yes | 2 No |
What is the physical storage length of date data type?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
How to access db2 tables in mainframe?
what is db2 restart?
What is ibm db2 client?
Can we update view in db2?
Mention the downsides of page level lock.
What is meant by a unit of recovery?
What is meant by explain?
What will the FREE command do to a plan?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?