Oracle
1Z0-082 · Question #36
Which three statements are true about views in an Oracle database? (Choose three.)
The correct answer is B. Tables in the defining query of a view must always exist in order to create 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. See the full explanation below for the reasoning.
Manage Schema Objects
Question
Which three statements are true about views in an Oracle database? (Choose three.)
Options
- AViews can be updated without the need to re-grant privileges on the view
- BTables in the defining query of a view must always exist in order to create the view
- CThe WITH CHECK clause prevents certain rows from being displayed when querying the view
- DData Manipulation Language (DML) can always be used on views
- EInserting one or more rows using a view whose defining query contains a GROUP BY clause will
- FDeleting one or more rows using a view whose defining query contains a GROUP BY clause will
- GThe WITH CHECK clause prevents certain rows from being updated or inserted
How the community answered
(23 responses)- A9% (2)
- B78% (18)
- C4% (1)
- F9% (2)
Topics
#views#WITH CHECK OPTION#GROUP BY views#DML on views
Community Discussion
No community discussion yet for this question.