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
C.
Index
is the answer really C?
yeap it is 🙂
Correct Answer is 1.Primary Key, 2. Foreign Key
Sorry this is wrong answer
this is the answer of question 129
HAyfa, while it is true that it’s the answer of question 129, question 129 is also an Index. In that case, StateId is a clustered index, which is why the answer is primary key (Since Primary Keys auto-generate a clustered index in SQL Server 2008+).
In summary, index is the most correct answer. I’ve got an MCSE in Windows Server, so get used to looking for the ‘most correct answer’ in problems like these; they seem to love throwing ‘gotcha’ answers at us.
How am I supposed to know there is a StateId column?
Correct Answer is C
Are these actual questions on the Exam? Help a girl out!