Oracle
1Z0-071 · Question #356
Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)
The correct answer is A. Insert statements can always be done on a table through a view. C. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY D. Delete statements can always be done on a table through a view. See the full explanation below for the reasoning.
Question
Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)
Options
- AInsert statements can always be done on a table through a view.
- BViews cannot be used to add rows to an underlying table if the table has columns with NOT NULL
- CViews cannot be used to query rows from an underlying table if the table has a PRIMARY KEY
- DDelete statements can always be done on a table through a view.
- EThe WITH CHECK clause has no effect when deleting rows from the underlying table through the
- FViews cannot be used to add or modify rows in an underlying table if the defining query of the
How the community answered
(20 responses)- A75% (15)
- B5% (1)
- E5% (1)
- F15% (3)
Community Discussion
No community discussion yet for this question.