Q127 Which three statements are true about views in an Oracle database?

0 Shares

Lượt xem: 123.516

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

(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