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

Discussion

For what purposes are views used?

  • A.To hide columns only
  • B.To hide rows only
  • C.To hide complicated SQL statements only
  • D.All of the above are uses for SQL views.

Answer: D

Correct answer: All of the above are uses for SQL views.

All three are standard uses and they often coincide. Restricting columns hides sensitive data and simplifies the result; restricting rows limits what a user may see; and wrapping a complicated statement behind a name means a user can query it as a simple table without knowing the joins beneath.

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

Post your comment

Please log in or register to post a comment.