nerdexam
Oracle

1Z0-071 · Question #396

Which statement is true about TRUNCATE and DELETE?

The correct answer is A. You can never TRUNCATE a table if foreign key constraints will be violated. Cannot truncate table 'Table' because it is being referenced by a FOREIGN KEY constraint. https://dba.stackexchange.com/questions/190073/truncate-tables-with-dependent-foreign-key-

Manipulating Data

Question

Which statement is true about TRUNCATE and DELETE?

Options

  • AYou can never TRUNCATE a table if foreign key constraints will be violated.
  • BFor large tables, DELETE is faster than TRUNCATE.
  • CFor tables with multiple indexes and triggers, DELETE is faster than TRUNCATE.
  • DYou can DELETE rows from a table with referential integrity constraints.

How the community answered

(37 responses)
  • A
    81% (30)
  • B
    11% (4)
  • C
    3% (1)
  • D
    5% (2)

Explanation

Cannot truncate table 'Table' because it is being referenced by a FOREIGN KEY constraint. https://dba.stackexchange.com/questions/190073/truncate-tables-with-dependent-foreign-key-

Topics

#TRUNCATE#DELETE#referential integrity#DDL vs DML

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-071 Practice