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

Discussion

Which of the following is an advantage of view?

  • A.Data security
  • B.Derived columns
  • C.Hiding of complex queries
  • D.All of the above

Answer: D

Correct answer: All of the above

A view gives all three. Security: users can be granted access to the view and not to the underlying table, so they see only certain rows or columns. Derived columns: a view can compute values that are not stored. Simplicity: a complex join can be defined once and then queried as though it were a single table.

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

Post your comment

Please log in or register to post a comment.