A Matching Index scan with equal predicate on a Unique index will return

When Can you be sure that a query will return only one row?

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

What language is db2 written in?

980

can we view the access paths created by dbrm ? how ? thx

6973

How to take backup of table in db2?

1021

What are the uses of db2 optimizer?

1223

What is a Foreign Key?

1036

What are concurrency issues?

1029

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1032

How can record locking be achieved in those DB2 versions which do not support it?

1019

What is null indicator in db2?

1051

What is concurrency?

1150

Is db2 relational database?

914

What types of tables are there in the db2 database?

1004

What is the role of the data page in the db2 database?

972

What are the various data types available in db2?

1012

How to find primary key of a table in db2?

1001