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

Discussion

Stored procedures have which of the following advantages?

  • A.It takes a longer time to write them as compared to writing Visual Basic.
  • B.Network traffic increases
  • C.Data integrity improves as multiple applications access the same stored procedure.
  • D.Result in thicker client and thinner database server.

Answer: C

Correct answer: Data integrity improves as multiple applications access the same stored procedure.

One procedure enforcing a rule means every application enforces it identically, and it cannot be forgotten in one of them. The other options are the reverse of the truth: stored procedures reduce network traffic by sending a call rather than a series of statements, and they make the client thinner rather than thicker.

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

Post your comment

Please log in or register to post a comment.