Exam 1z0-082 topic 1 question 125 discussion

Provided answer are corrects.

A) TRUE; see https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-VIEW.html#GUID-61D2D2B4-DACC-4C7C-89EB-7E50D9594D30 "Notes on Updatable Views". WITH CHECK OPTION prevents INSERT, UPDATE and DELETE in join views B) FALSE; same URL as in A), "subquery_restriction_clause, WITH CHECK OPTION" ... Oracle Database prohibits any changes to the table or view . This statements talks only about changes, not about reading the rows of a view. C) TRUE; https://www.oracletutorial.com/oracle-view/oracle-updatable-view/ no extra grants are mentioned D) FALSE; a view can be based on another view, see this example: SQL> CREATE TABLE a ( b int ); SQL> INSERT INTO a VALUES ( 0 ); SQL> CREATE VIEW v_a AS SELECT * FROM a; SQL> CREATE VIEW vv_a AS SELECT * FROM v_a; SQL> SELECT * FROM vv_a; B - 0 E) FALSE; https://asktom.oracle.com/pls/apex/asktom.search?tag=indexes-on-view