Machine-translated by Google. Questions are authored in English.
Top

Discussion

What is not an advantage of stored procedures?

  • A.Greater security
  • B.SQL can be optimized
  • C.Code sharing
  • D.Increased network traffic

Answer: D

Correct answer: Increased network traffic

Stored procedures reduce network traffic, since only the call and its parameters cross the network instead of the statements and their intermediate results. The other three are genuine advantages: permissions can be granted on the procedure rather than the tables, the plan is compiled and reused, and the code is written once and shared.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.