Which one is true ?
-
A view can be created as a join on two or more tables
-
A view can't be created as a join on two or more tables
-
A view can't have an ORDER BY clause in SELECT statement
-
A view can't be created with a GROUP BY clause in SELECT statement
Reveal answer
Fill a bubble to check yourself
A
Correct answer
Explanation
Views CAN be created as joins across multiple tables - this is a common use case for simplifying complex queries. Views can also include ORDER BY in some databases (with limitations), and GROUP BY is standard. Option A is correct. Option B directly contradicts A. Options C and D are false - views can include ORDER BY (with TOP/LIMIT in some DBs) and definitely support GROUP BY.