Oracle Database Administration I — Question 7

Which three statements are true about views in an Oracle database? (Choose three.)

Answer options

• A. Views can be updated without the need to re-grant privileges on the view
• B. Tables in the defining query of a view must always exist in order to create the view
• C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
• D. Data Manipulation Language (DML) can always be used on views
• E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• G. The WITH CHECK clause prevents certain rows from being updated or inserted

Correct answer: A, F, G

Explanation

Statement A is correct because views can indeed be updated without requiring a re-grant of privileges. Statement F is true as deleting from a view defined with a GROUP BY clause will lead to an error since the operation cannot be unambiguously mapped to the underlying table. Statement G is also correct because the WITH CHECK clause is designed to restrict certain rows from being inserted or updated based on the defined criteria, while the other statements do not accurately describe the behavior of views.