Which statement about views is correct?
A) A view can join two or more tables and/or involve statistics.
B) A view is a temporary table the DBMS creates in response to a query.
C) A query of a view is executed in the form in which the user enters it.
D) The column names in a view must match those in the base table(s).

Question

Quizplus · Accepted Answer

A view can indeed join two or more tables and can involve statistics. It is a virtual table based on the result-set of an SQL statement. It does not necessarily have to be a temporary table, nor does the query of a view execute exactly as entered by the user in all cases. Column names in a view do not have to match those in the base table(s); they can be renamed as part of the view definition.

Which Statement About Views Is Correct