nerdexam
Oracle

1Z0-071 · Question #258

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

The correct answer is A. DELETE can be used to remove rows from only one table in one statement. E. DELETE and TRUNCATE can be used for tables that are parents for a child table that has a. See the full explanation below for the reasoning.

Question

Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

Options

  • ADELETE can be used to remove rows from only one table in one statement.
  • BDELETE can be used to remove rows from multiple tables in one statement.
  • CDELETE can be used to remove rows only for tables that are parents for a child table that has a
  • DDELETE can be used to remove data from specific columns as well as complete rows.
  • EDELETE and TRUNCATE can be used for tables that are parents for a child table that has a

How the community answered

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

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice