Multiple choice technology programming languages

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

  1. A view can be created as read only.

  2. A view can be created as a join on two or more tables

  3. A view cannot have a n ORDER BY clause in the SELECT statement.

  4. A view cannot be created with a GROUP BY clause in the SELECT statement.
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Views can be created as read-only using the WITH CHECK OPTION or through complex queries. Views can join multiple tables - that's one of their main purposes. Views CAN have ORDER BY in Oracle if used with a subquery. Views CAN use GROUP BY for aggregation.

Keep practicing — related questions