Oracle
1Z0-074 · Question #84
1Z0-074 Question #84: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #84. The question stem and answer options stay visible for context.
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
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.