When Can you be sure that a query will return only one row?
Answer Posted / s
A Matching Index scan with equal predicate on a Unique
index will return only one row.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is schema in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Explain the function done by data manager?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How do I add a column to an existing table in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Can you tell me how can you find out the # of rows updated after an update statement?
What is sqlca?
What is the information associated with sysibm.syslinks table?
What is the difference between bind and rebind in db2?
What is db2 stogroup?
What does db2 stand for?
What is the use of reorg in db2?
Why do chiropractors use drop table?
What is db2 bind?