DELETE vs TRUNCATE behavior in SQL - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to delete all rows from the table named 'employees'.

SQL

DELETE FROM [1];

Drag options to blanks, or click blank then click option'

Aemployee

Bemp

Cemployees

Dstaff

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong table name like 'employee' or 'emp'.

Forgetting the semicolon at the end.

The correct table name is 'employees'. This command deletes all rows from that table.

2fill in blank

medium

Complete the code to remove all rows quickly from the table named 'orders' without logging individual row deletions.

SQL

TRUNCATE TABLE [1];

Drag options to blanks, or click blank then click option'

Aorders

Border_table

Corder_list

Dorder

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular form 'order' instead of 'orders'.

Confusing TRUNCATE with DELETE syntax.

TRUNCATE TABLE orders removes all rows quickly and resets storage without logging each row deletion.

3fill in blank

hard

Fix the error in the command to delete rows from 'customers' where the city is 'Paris'.

SQL

DELETE FROM customers WHERE city [1] 'Paris';

Drag options to blanks, or click blank then click option'

A===

B==

Cequals

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' or '===' instead of '='.

Writing 'equals' as a word instead of '='.

In SQL, the equality operator is '='. Using '==' or '===' causes syntax errors.

4fill in blank

hard

Fill both blanks to write a command that deletes all rows from 'products' but logs each deletion.

SQL

DELETE FROM [1] WHERE [2];

Drag options to blanks, or click blank then click option'

Aproducts

B1=1

CTRUE

D0=0

Attempts:

3 left

💡 Hint

Common Mistakes

Using TRUNCATE instead of DELETE for logging.

Using a false condition in WHERE clause.

DELETE FROM products WHERE 1=1 deletes all rows and logs each deletion. '1=1' is always true.

5fill in blank

hard

Fill the blanks to write a command that truncates the 'logs' table and resets identity counters.

SQL

TRUNCATE TABLE [1] [2] RESTART IDENTITY;

Drag options to blanks, or click blank then click option'

Alogs

BCASCADE

CONLY

DIF EXISTS

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting CASCADE when dependent tables exist.

Forgetting RESTART IDENTITY.

TRUNCATE TABLE logs CASCADE RESTART IDENTITY; truncates logs, resets IDs, and cascades to dependent tables.