Which two statements about views are true? ()
- 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 cannot have an ORDER BY clause in the SELECT statement.
- D A view cannot be created with a GROUP BY clause in the SELECT statement.
- E A view must have aliases defined for the column names in the SELECT statement.