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


Please Help Members By Posting Answers For Below Questions

How to execute stored procedures?

831


What is cursor in dbms?

817


What is the maximum size of varchar data type in db2?

842


What is plan in cobol db2?

788


What is the maximum size of a char data type in db2?

769


What is the latest version of ibm db2?

952


Explain about rct in db2?

864


Is schema the same as database?

813


define clustering index.

795


How do I connect my db2 database to ibm?

788


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1484


What is rct?

968


What is a db2 package?

783


Why do we need reorg in db2?

733


Explain packages.

861