You work as a Database Administrator for Domain.com. The company uses MySQL as its database.
You have created a table named Employees in the database. The structure of the table is as follows:
Now, you want to rename the Emp_join_date column to Joining_date. Which of the following
statements is true according to the scenario?
A.
The column can be renamed by using the UPDATE statement.
B.
The column can be renamed by using the ALTER TABLE statement.
C.
The column can be renamed by using the TRUNCATE statement.
D.
The column can be renamed by using the RENAME statement.