What is the difference between DELETE FROM Logs, TRUNCATE TABLE Logs and DROP TABLE Logs?

Quelle est la différence entre DELETE FROM Logs, TRUNCATE TABLE Logs et DROP TABLE Logs ?

Answers

AAll three remove only the table's structure, and leave every row of data untouched for later reuse by the applicationLes trois ne suppriment que la structure de la table et laissent chaque ligne de données intacte pour une réutilisation ultérieure par l'application

BDELETE removes the table; TRUNCATE removes one row; DROP removes indexes onlyDELETE supprime la table ; TRUNCATE supprime une ligne ; DROP ne supprime que les index

CDELETE removes rows one by one (filterable); TRUNCATE empties it fast; DROP removes the table itselfDELETE supprime les lignes une à une (filtrable) ; TRUNCATE la vide vite ; DROP supprime la table elle-même

DThey are identicalElles sont identiques

The answer and explanation are in the full bank.

This question is one of 2,831 in the paid banks. Each comes with the correct answer and the reasoning behind it, not just a mark.

Unlock for 5,000 RWF

MIFOTRA exam practicealigned to Practice set: Database Management·3 marks·Hard

What is the difference between DELETE FROM Logs, TRUNCATE TABLE Logs and DROP TABLE Logs?

More Database questions