Which two statements about views are true? (Choose two.)
A.
A view can be created as read only.
B.
A view can be created as a join on two or more tables.
C.
A view must have aliases defined for the column names in the SELECT statement.
D.
A view cannot be created with a GROUP BY clause in the SELECT statement.
E.
A view cannot have an ORDER BY clause in the SELECT statement.
Explanation:
A view can becreated as read only object. However, it is possible to change data in the underlying
table(s) with some restrictions.A view also can be created as a join on two or more tables. This
type of view is called complex view. Complex views provide complicated data models where many
base tables are drawn together into one virtual table.