CREATE INDEX syntax in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create an index named idx_name on the column col1 of the table my_table.

SQL

CREATE INDEX [1] ON my_table (col1);

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

Atable_index

Bmy_index

Cindex1

Didx_name

Attempts:

3 left

💡 Hint

Common Mistakes

Using the table name instead of the index name.

Omitting the index name.

Using a column name as the index name.

The index name follows the CREATE INDEX keyword. Here, idx_name is the correct index name.

2fill in blank

medium

Complete the code to create a unique index named unique_idx on the column email of the table users.

SQL

CREATE [1] INDEX unique_idx ON users (email);

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

AUNIQUE

BTEMPORARY

CFULLTEXT

DCLUSTERED

Attempts:

3 left

💡 Hint

Common Mistakes

Using TEMPORARY which is for temporary tables, not indexes.

Using FULLTEXT which is for text search indexes.

Using CLUSTERED which is not standard SQL syntax.

The keyword UNIQUE creates an index that enforces uniqueness on the column values.

3fill in blank

hard

Fix the error in the code to create an index named idx_age on the age column of the table persons.

SQL

CREATE INDEX idx_age [1] persons (age);

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

AON

BIN

CFOR

DTO

Attempts:

3 left

💡 Hint

Common Mistakes

Using IN or FOR which are not valid here.

Omitting the keyword ON.

The correct syntax uses the keyword ON before the table name.

4fill in blank

hard

Fill both blanks to create a unique index named idx_unique on the columns col1 and col2 of the table data_table.

SQL

CREATE [1] INDEX idx_unique [2] data_table (col1, col2);

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

AUNIQUE

BTEMPORARY

CON

DIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using TEMPORARY instead of UNIQUE.

Using IN instead of ON.

The first blank needs UNIQUE to make the index unique. The second blank needs ON to specify the table.

5fill in blank

hard

Fill all three blanks to create a fulltext index named idx_fulltext on the column description of the table products.

SQL

CREATE [1] INDEX [2] [3] products (description);

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

AFULLTEXT

Bidx_fulltext

CON

DUNIQUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using UNIQUE instead of FULLTEXT.

Omitting the ON keyword.

Swapping the order of index name and index type.

The first blank is the index type FULLTEXT. The second blank is the index name idx_fulltext. The third blank is the keyword ON before the table name.