perform worse than clustered indexes on ranged searches where the result set is large, since each result could cost an additional I/O-operation to ...

search for b># using non-clustered index on b

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on e...

Q1 a) Explain why it is not possible to have more than one clustered index per relation