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

Discussion

Which of the following database objects does not physically exist?

  • A.Base table
  • B.Index
  • C.View
  • D.None of the above

Answer: C

Correct answer: View

A view is a stored query: it has no data of its own, and its rows are computed whenever it is referenced. Base tables and indexes both occupy real storage. (A materialised view is the exception that proves the rule - it is stored precisely because an ordinary view is not.)

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

Post your comment

Please log in or register to post a comment.