You have a SQL Server 2012 database named Database1.
You execute the following code:
You insert 3 million rows into Sales.
You need to reduce the amount of time it takes to execute Proc1.
What should you do?
A.
ProductType varchar(11) ‘@ProductType’,
B.
ProductType varchar(11) ‘ProductType/ID’,
C.
ProductType varchar(11) ‘ProductType/@ID’,
D.
ProductType varchar(11) ‘ProductType1’.
Completely wrong answers
These are not the answer for this question !!!!!!
No correct answer !
The answer should be
Change Query to prod1 to
select ID,Order Date,Amount
………..Between….
……………
Order by ID
This is Duplicate to Question 48
wrong choices for the question. this is dup question