nerdexam
Oracle

1Z0-082 · Question #36

Which three statements are true about views in an Oracle database? (Choose three.)

The correct answer is B. Tables in the defining query of a view must always exist in order to create the view D. Data Manipulation Language (DML) can always be used on views E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will. See the full explanation below for the reasoning.

Manage Schema Objects

Question

Which three statements are true about views in an Oracle database? (Choose three.)

Options

  • AViews can be updated without the need to re-grant privileges on the view
  • BTables in the defining query of a view must always exist in order to create the view
  • CThe WITH CHECK clause prevents certain rows from being displayed when querying the view
  • DData Manipulation Language (DML) can always be used on views
  • EInserting one or more rows using a view whose defining query contains a GROUP BY clause will
  • FDeleting one or more rows using a view whose defining query contains a GROUP BY clause will
  • GThe WITH CHECK clause prevents certain rows from being updated or inserted

How the community answered

(23 responses)
  • A
    9% (2)
  • B
    78% (18)
  • C
    4% (1)
  • F
    9% (2)

Topics

#views#WITH CHECK OPTION#GROUP BY views#DML on views

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice