CASCADE delete preview in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to delete a row from the parent table.

SQL

DELETE FROM parent_table WHERE id = [1];

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

A'10'

B10

Cid

Dparent_id

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around numeric id values.

Using column names instead of values.

We use the actual id value (10) without quotes because id is numeric.

2fill in blank

medium

Complete the code to preview rows in the child table that will be deleted due to CASCADE.

SQL

SELECT * FROM child_table WHERE parent_id = [1];

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

A'10'

Bparent_id

C10

Did

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around numeric values.

Using column names instead of values.

We use the numeric value 10 to match the parent_id column.

3fill in blank

hard

Fix the error in the CASCADE delete preview query.

SQL

SELECT * FROM child_table WHERE parent_id = [1];

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

A10

B'10'

C'10';

D10;

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting the semicolon at the end.

Using quotes around numeric values.

The semicolon is needed to end the SQL statement properly.

4fill in blank

hard

Fill both blanks to preview and then delete rows with CASCADE.

SQL

SELECT * FROM child_table WHERE parent_id = [1];
DELETE FROM parent_table WHERE id = [2];

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

A10

B'10'

Cid

Dparent_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around numeric values.

Using column names instead of values.

Use the numeric value 10 for both preview and delete to match the parent row.

5fill in blank

hard

Fill all three blanks to preview child rows, delete parent row, and confirm deletion.

SQL

SELECT * FROM child_table WHERE parent_id = [1];
DELETE FROM parent_table WHERE id = [2];
SELECT * FROM child_table WHERE parent_id = [3];

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

A10

B'10'

Cid

Dparent_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around numeric values.

Using column names instead of values.

Use the numeric id 10 consistently to preview, delete, and confirm child rows.