> > >

MySQL MCQs

Which of the following statements regarding the TRUNCATE TABLE statement are correct in MySOL 5.6?

Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables.

Truncate operations cause an implicit commit, and so cannot be rolled back.

Truncation operations cannot be performed if the session holds an active table lock.

The TRUNCATE TABLE statement does not invoke ON DELETE triggers.

All of the above.

Answer

Correct Answer: All of the above.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it