Solved

A View May Not Be Updated Directly If It Contains

Question 103

Multiple Choice

A view may not be updated directly if it contains:

A) the distinct keyword.
B) derived columns and expressions in the select clause.
C) uses the group by or having clause.
D) all of the above.

Related Questions

Q7: What does the following SQL statement do?

Q26: The WHERE clause is always processed before

Q39: Materialized views are stored on disk and

Q69: DCL is used to update the database

Q89: The following query totals sales in state=

Q98: Any create command may be reversed by

Q100: The _ contains raw data.

Q104: The _ is a set of commands

Q105: What result set will the following query

Q107: The DROP TABLE command causes tables to