Multiple choices 25/50
(Choose 1 answer)
Next
What makes stored procedures faster than sending a Transact-SQL statement to SQL Server?
A. They are not faster.
B. The query plan is compiled and cached on the server.
C. The Transact-SQL statements are shorter.
D. There are less commands available, so parsing time is shorter
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 16 17
18
19 20
21
22
23
24
25 26
27 28
29
30
31
32
33
34
35
36
37
38
39
40 41 47
43
44
45 46 47 48
49 50
