Rename operation in DBMS Theory - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to rename a table from old_table to new_table.

DBMS Theory

ALTER TABLE old_table [1] new_table;

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

ARENAME TO

BUPDATE TO

CMODIFY TO

DCHANGE TO

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'CHANGE TO' or 'MODIFY TO' instead of 'RENAME TO'.

Forgetting the 'TO' keyword after 'RENAME'.

In SQL, the correct syntax to rename a table is ALTER TABLE old_table RENAME TO new_table;. The keyword RENAME TO is used for this operation.

2fill in blank

medium

Complete the code to rename a column old_column to new_column in the table my_table.

DBMS Theory

ALTER TABLE my_table [1] old_column new_column VARCHAR(50);

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

AUPDATE COLUMN

BRENAME COLUMN

CMODIFY COLUMN

DCHANGE COLUMN

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'RENAME COLUMN' which is not supported in all SQL dialects.

Omitting the data type when renaming a column.

To rename a column in many SQL databases like MySQL, the syntax is ALTER TABLE my_table CHANGE COLUMN old_column new_column VARCHAR(50);. The keyword CHANGE COLUMN is used along with the new column definition.

3fill in blank

hard

Fix the error in the code to rename a table from users to customers.

DBMS Theory

ALTER TABLE users [1] customers;

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

ACHANGE TO

BRENAME TO

CMODIFY TO

DUPDATE TO

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'CHANGE TO' which is incorrect for renaming tables.

Forgetting the 'TO' keyword after 'RENAME'.

The correct syntax to rename a table is ALTER TABLE users RENAME TO customers;. Using RENAME TO is the standard and correct keyword.

4fill in blank

hard

Fill both blanks to rename a column address to location with type VARCHAR(100) in the table employees.

DBMS Theory

ALTER TABLE employees [1] address [2] location VARCHAR(100);

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

ACHANGE COLUMN

BRENAME COLUMN

CTO

DAS

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'RENAME COLUMN' which is not supported in all SQL dialects.

Using 'AS' instead of 'TO' between column names.

The correct syntax to rename a column in many SQL dialects is ALTER TABLE employees CHANGE COLUMN address location VARCHAR(100);. The keywords CHANGE COLUMN are used and the old and new column names are listed consecutively.

5fill in blank

hard

Fill all three blanks to rename a table orders to sales_orders and rename column order_date to sale_date with type DATE.

DBMS Theory

ALTER TABLE [1] [2] sales_orders; ALTER TABLE sales_orders [3] order_date sale_date DATE;

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

Aorders

BRENAME TO

CTO

DCHANGE COLUMN

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the order of commands.

Using incorrect keywords like 'MODIFY' instead of 'CHANGE COLUMN'.

First, rename the table using ALTER TABLE orders RENAME TO sales_orders;. Then rename the column with ALTER TABLE sales_orders CHANGE COLUMN order_date sale_date DATE;. The blanks correspond to the old table name, the rename keyword, and the column rename keyword.