A table Student (SID, Sname, Course, Grade) where SID has a Unique Constraint is created successfully.
Tony and Steve is having the following discussion:
Tony says we can create Clustered index on column SID
Steve says we can create Non-Clustered Index on column SID
Identify whose statement is correct

Question

A table Student (SID, Sname, Course, Grade) where SID has a Unique Constraint is created successfully.

Tony and Steve is having the following discussion:

Tony says we can create Clustered index on column SID

Steve says we can create Non-Clustered Index on column SID

Identify whose statement is correct

anonymous · Accepted Answer

Correct Solution - c

A table Student (SID, Sname, Course, Grade) where SID has a Unique Constraint is created successfully.Tony and Steve is having the following discussion:Tony says we can create Clustered index on column SIDSteve says we can create Non-Clustered Index on column SIDIdentify whose statement is correct