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 is the use of db2 optimizer?

1067

What is runstats and reorg in db2?

1257

what is utility for parm lib

2327

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

1057

What is runstats db2?

977

How and when does the db2 enforces the unique key?

1057

Which command is used to connect to a database in DB2 ? Give the Syntax.

1050

What is db2 optimizer?

1198

What is the difference between dbm cfg and db cfg file in db2 ?

1493

What is the difference between bind and rebind in db2?

1415

Can we insert update delete in view?

922

What action db2 takes when a program aborts in the middle of a transaction?

1115

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

What is dbrm in db2 database?

1058

Mention the different locking levels that are available in db2.

1096