Exit 98-364 Database Fundamentals
Question 2 of 5
0% complete
Q2 Single choice

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