nerdexam
Oracle

1Z0-071 · Question #313

Which three statements are true about performing Data Manipulation Language (DML) operations on a view in an Oracle Database? (Choose three.)

The correct answer is B. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY C. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL F. Views cannot be used to add or modify rows in an underlying table if the defining query of the. See the full explanation below for the reasoning.

Question

Which three statements are true about performing Data Manipulation Language (DML) operations on a view in an Oracle Database? (Choose three.)

Options

  • AViews cannot be used to add or modify rows in an underlying table if the defining query of the
  • BViews cannot be used to query rows from an underlying table if the table has a PRIMARY KEY
  • CViews cannot be used to add rows to an underlying table if the table has columns with NOT NULL
  • DThe WITH CHECK clause has no effect when deleting rows from the underlying table through the
  • EInsert statements can always be done on a table through a view.
  • FViews cannot be used to add or modify rows in an underlying table if the defining query of the

How the community answered

(26 responses)
  • A
    12% (3)
  • B
    81% (21)
  • D
    4% (1)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice