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 difference between CS and RR isolation levels?
what needs to be done if a table is in copy pending / check pending status?
What is a plan and package in db2?
What are the three types of page locks that can be held?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
what is the use of cursors?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is meant by index cardinality?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is ibm db2 used for?