nerdexam
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)
  • A
    74% (26)
  • B
    3% (1)
  • E
    6% (2)
  • F
    17% (6)

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice