Database creation and selection in MySQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new database named 'school'.

MySQL

CREATE DATABASE [1];

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

Aschool

Bcreate

Ctable

Duse

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'create' or 'table' instead of the database name.

Forgetting to specify the database name.

The CREATE DATABASE statement is used to create a new database. You need to specify the database name after it.

2fill in blank

medium

Complete the code to select the database named 'library' for use.

MySQL

USE [1];

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

Acreate

Btable

Clibrary

Dselect

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'create' or 'select' instead of the database name.

Forgetting the semicolon at the end.

The USE statement tells MySQL which database to work with. You must specify the database name after USE.

3fill in blank

hard

Fix the error in the code to create a database named 'company'.

MySQL

CREATE [1] company;

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

Atable

Bselect

Cuse

Ddatabase

Attempts:

3 left

💡 Hint

Common Mistakes

Using CREATE TABLE instead of CREATE DATABASE.

Using USE or SELECT in place of DATABASE.

The correct keyword to create a database is DATABASE. Using TABLE or other keywords will cause an error.

4fill in blank

hard

Fill both blanks to create and then select a database named 'shop'.

MySQL

[1] DATABASE shop; [2] shop;

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

ACREATE

BDROP

CUSE

DSELECT

Attempts:

3 left

💡 Hint

Common Mistakes

Using DROP instead of CREATE to make the database.

Using SELECT instead of USE to select the database.

First, you create the database with CREATE DATABASE. Then, you select it with USE to start working inside it.

5fill in blank

hard

Fill all three blanks to create a database named 'music', select it, and then drop it.

MySQL

[1] DATABASE music; [2] music; [3] DATABASE music;

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

ACREATE

BUSE

CDROP

DSELECT

Attempts:

3 left

💡 Hint

Common Mistakes

Using SELECT instead of USE to select the database.

Using DROP before creating the database.

You first create the database with CREATE DATABASE, then select it with USE, and finally remove it with DROP DATABASE.