Microsoft Exam Questions

Which item should you add to the Salary column?

You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query
takes too much time to return data. You need to improve the performance of the query. Which item
should you add to the Salary column?

A.
Non-null constraint

B.
Default constraint

C.
Index

D.
Foreign key