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

Discussion

SQL views can be used to hide:

  • A.columns and rows only.
  • B.complicated SQL syntax only.
  • C.both of the above can be hidden by an SQL view.
  • D.None of the above is correct.

Answer: C

Correct answer: both of the above can be hidden by an SQL view.

A view can restrict which columns and which rows a user sees, which serves security and simplicity at once; and because the view is defined by a SELECT, the joins, subqueries and computations in that statement are hidden behind a name. Users then query the view as though it were a simple table.

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

Post your comment

Please log in or register to post a comment.