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
7
0
is the answer really C?
5
0
yeap it is 🙂
5
0
Correct Answer is 1.Primary Key, 2. Foreign Key
0
10
Sorry this is wrong answer
4
0
this is the answer of question 129
0
0
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.
1
0
How am I supposed to know there is a StateId column?
0
0
Correct Answer is C
2
0
Are these actual questions on the Exam? Help a girl out!
0
0
no kim they made these questions up
whos going to compensate you
1
0
The answer is C: Indexes are special lookup tables that the database search engine can use to speed up data retrieval. An index is a pointer to a data in a table. An index helps to speed up SELECT queiries and WHERE clauses, but it slows down data input, with the UPDATE and the INSERT statements. Indexes can be unique, in that the index prevents duplicate entries in the column or combination of columns on which there is an index.
3
0