SQL 면접 질문과 답변
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. |
복습용 저장
이 항목을 북마크하거나, 어렵게 표시하거나, 복습 세트에 넣을 수 있습니다.
도움이 되었나요? 예 아니요
Most helpful rated by users: