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

How does coalesce work?

1014

What is page size in db2?

972

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

1104

How to find primary key of a table in db2?

1062

How do I add a column to an existing table in db2?

1030

What is db2 purescale?

993

What is the difference between bind and rebind in db2?

1449

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1274

How can you count the number of rows from a table tab?

1087

What is rct?

1229

Explain the benefits you can get from mainframe connect?

970

How to restart a DB2 program?

1897

On which levels locks can be applied?

1123

What is runstats db2?

1019

Comment whether the cursor is closed during commit or not.

1098