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

Question

Options

• AA view can be created as read only.
• BA view can be created as a join on two or more tables.
• CA view cannot have an ORDER BY clause in the SELECT statement.
• DA view cannot be created with a GROUP BY clause in the SELECT statement.
• EA view must have aliases defined for the column names in the SELECT statement.

• A
  85% (33)
• C
  3% (1)
• D
  5% (2)
• E
  8% (3)

Explanation

A view can becreated as read only object. However, it is possible to change data in the underlying table(s) with some restrictions. A view also can be created as a join on two or more tables. This type of view is called complex view. Complex views provide complicated data models where many base tables are drawn together into one virtual table. Incorrect Answers C: Query operations containing ORDER BY clause are also permitted, so long as the ORDER BY clause appearsoutside the parentheses. The following is an example of what I mean: CREATE VIEW my_view AS (SELECT*FROM emp) D: A view can be created with a GROUP BY clause in the SELECT statement. E: It is not required to have aliases defined for the column names in the SELECT statement.

No community discussion yet for this question.