|A) Complicated SQL syntax||B) Rows|
|C) Columns||D) All of the above|
In SQL, a SQL view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table.
SQL views can be used to hide rows and columns and complicated SQL syntax.
The fields in a view are fields from one or more real tables in the database.