SQL preguntas y respuestas de entrevista
Question: What is the difference between TRUNCATE and DELETE commands?Answer: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.DELETE is a DML command and can be rolled back. Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster. |
Guardar para repaso
Guarda este elemento en marcadores, marcalo como dificil o agregalo a un conjunto de repaso.
Inicia sesion para guardar marcadores, preguntas dificiles y conjuntos de repaso.
Es util? Si No
Lo mas util segun los usuarios: