Oracle
1Z0-074 · Question #84
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 and the 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 and the
- 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 view.
- FViews cannot be used to add or modify rows in an underlying table if the defining query of the view
How the community answered
(35 responses)- A74% (26)
- B3% (1)
- E6% (2)
- F17% (6)
Community Discussion
No community discussion yet for this question.