Online Tutorials & Training Materials | STechies.com
Register Login

Which two statements about views are true? (Choose two)

Shalesh Singh Visen || 09 Mar 2008 10:19 am || 0

Q. 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 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.

Answer: AB