Oracle Database Administration I — Question 125

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

Answer options

• A. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
• B. The WITH CHECK clause prevents certain rows from being displayed when querying the view.
• C. Views can be updated without the need to re-grant privileges on the view.
• D. A view must only refer to tables in its defining query.
• E. Views can be indexed.

Correct answer: A, C

Explanation

The correct answer A indicates that the WITH CHECK clause restricts certain rows from being updated or inserted, ensuring data integrity. Option C is also correct as views can be updated without re-granting privileges, simplifying permission management. Options B and D are incorrect because the WITH CHECK clause does not affect displayed rows and views can reference multiple tables. Option E is incorrect as views themselves cannot be indexed.