Platform edukasi untuk persiapan wawancara, tes online, tutorial, dan latihan langsung

Bangun keterampilan dengan jalur belajar terfokus, tes simulasi, dan konten siap wawancara.

WithoutBook menghadirkan pertanyaan wawancara per subjek, tes latihan online, tutorial, dan panduan perbandingan dalam satu ruang belajar yang responsif.

Cari di perpustakaan

Prepare Interview

SQL Pertanyaan dan Jawaban Wawancara

← Previous
Next →

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.

Simpan untuk Revisi

Bookmark item ini, tandai sebagai sulit, atau masukkan ke dalam set revisi.

Buka Perpustakaan Belajar Saya

Apakah ini membantu? Ya Tidak

Most helpful rated by users:

What is SQL?
SQL*Plus
Date Functions
NVL
Character Functions