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

Posted on 29/10/2024 by Tran Anh

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

Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận