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

Which command is used to remove all rows from a table?

552


Why do we bind in db2?

629


How do I import a csv file into db2?

558


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1816


i want to maintain uniqueness on pdf without make lf??????????

1629






How would the varchar column remarks defined?

633


What is catalog database in db2?

640


What is a db2 package?

597


What is a plan and package in db2?

617


What is cursor in dbms?

587


What is explain in db2?

582


What is the maximum No of rows per page?

626


What is rebind in db2?

574


What is null in db2?

571


What is cursor stability in db2?

806