Multiple choice technology databases

Which two statements about view 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 can not have an ORDER BY clause in the SELECT statement D. A view can not 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

  1. C, D

  2. A, E

  3. A, B

  4. B, D
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Views in SQL can be created with the CHECK OPTION to make them read-only, and can join multiple tables. Views can have ORDER BY in some databases (though with limitations), and GROUP BY is allowed. Column aliases are optional - the view can use original column names.

AI explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) A view can be created as read-only - This option is correct. Views can be created as read-only, meaning that data can be queried from the view but not modified.

Option B) A view can be created as a join on two or more tables - This option is correct. Views can be created as a result of joining two or more tables, providing a consolidated and simplified view of the data.

Option C) A view cannot have an ORDER BY clause in the SELECT statement - This option is incorrect. Views can have an ORDER BY clause in the SELECT statement to specify the sorting of the result set.

Option D) A view cannot be created with a GROUP BY clause in the SELECT statement - This option is incorrect. Views can have a GROUP BY clause in the SELECT statement to group the data based on specified criteria.

Option E) A view must have aliases defined for the column names in the SELECT statement - This option is incorrect. While it is recommended to provide aliases for column names in a view, it is not mandatory. Views can be created without aliases for column names.

The correct answer is C) A, B. This option is correct because both statements are true. Views can be created as read-only (A), and views can be created as a join on two or more tables (B).

Keep practicing — related questions