INSERT with DEFAULT values in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert a new row using the default values for all columns.

SQL

INSERT INTO employees [1];

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

ADEFAULT VALUES

BVALUES ()

CVALUES (DEFAULT)

DSET DEFAULT

Attempts:

3 left

💡 Hint

Common Mistakes

Using VALUES () which is invalid syntax for default insertion.

Trying to use SET DEFAULT which is not valid here.

The correct syntax to insert a row with all default values is INSERT INTO table DEFAULT VALUES;

2fill in blank

medium

Complete the code to insert a new row with default values in the 'departments' table.

SQL

INSERT INTO departments [1];

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

ADEFAULT VALUES

BVALUES ()

CSET DEFAULT

DVALUES (DEFAULT)

Attempts:

3 left

💡 Hint

Common Mistakes

Using VALUES (DEFAULT) which is invalid without specifying columns.

Using VALUES () which is not accepted for default insertion.

To insert a row with all default values, use DEFAULT VALUES after the table name.

3fill in blank

hard

Fix the error in the code to insert a default row into the 'projects' table.

SQL

INSERT INTO projects [1];

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

AVALUES (DEFAULT)

BSET DEFAULT

CDEFAULT VALUES

DVALUES ()

Attempts:

3 left

💡 Hint

Common Mistakes

Using VALUES () which is not valid syntax.

Trying to use SET DEFAULT which is not a valid clause here.

The correct syntax to insert a row with default values is INSERT INTO projects DEFAULT VALUES;. Using VALUES () causes a syntax error.

4fill in blank

hard

Fill both blanks to insert a row with default values into the 'tasks' table.

SQL

INSERT INTO [1] [2];

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

Atasks

BDEFAULT VALUES

CVALUES ()

DSET DEFAULT

Attempts:

3 left

💡 Hint

Common Mistakes

Using VALUES () instead of DEFAULT VALUES.

Using SET DEFAULT which is invalid here.

The correct syntax is INSERT INTO tasks DEFAULT VALUES; to insert a row with default values.

5fill in blank

hard

Fill all three blanks to insert a default row into the 'clients' table.

SQL

INSERT INTO [1] [2] [3];

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

Aclients

BDEFAULT

CVALUES

DVALUES ()

Attempts:

3 left

💡 Hint

Common Mistakes

Using VALUES () which is invalid for default insertion.

Splitting DEFAULT VALUES incorrectly.

The correct syntax to insert default values is INSERT INTO clients DEFAULT VALUES;. Here, the blanks represent the table name, the keyword DEFAULT, and the keyword VALUES respectively.