ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 174 discussion

Actual exam question from Oracle's 1z0-071
Question #: 174
Topic #: 1
[All 1z0-071 Questions]

Which statement is true about TRUNCATE and DELETE?

  • A. For tables with multiple indexes and triggers DELETE is faster than TRUNCATE.
  • B. For large tables TRUNCATE is faster than DELETE.
  • C. You can never TRUNCATE a table if foreign key constraints will be violated.
  • D. You can never DELETE rows from a table if foreign key constraints will be violated.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Ricx24 at Feb. 21, 2023, 3:56 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
JayaprasanthGurunathan
2 months, 3 weeks ago
Selected Answer: C
You cannot truncate the parent table of an enabled foreign key constraint. You must disable the constraint before truncating the table. An exception is that you can truncate the table if the integrity constraint is self-referential.
upvoted 1 times
...
kay000001
5 months, 1 week ago
Selected Answer: C
Answer is C. The key word is 'if' foreign contstraints will be be violated. Meaning, the TRUNCATE 'will' violate the foreign constraints.
upvoted 1 times
...
lucemqy
1 year, 5 months ago
Selected Answer: B
B correct answer should be B
upvoted 1 times
...
jm9999
1 year, 6 months ago
Selected Answer: B
the exception to C is if the constraint is self referential which contradicts the user of 'never' in the statement
upvoted 1 times
...
Darnun
2 years ago
Selected Answer: B
https://www.examtopics.com/discussions/oracle/view/15064-exam-1z0-071-topic-1-question-268-discussion/
upvoted 2 times
...
Ricx24
2 years, 1 month ago
Selected Answer: B
The correct answer is B (Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables)
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago