Q536
The statement used to change the table name is . . . . . . . .
A.
RENAME
AnswerB.
CHANGE
C.
CHANGENAME
D.
CHANGENM
Answer: Option A
Solution
Answer: Option A
Solution:
This question asks about how to rename a table in MySQL. Let's break it down:
Imagine you have a table named "students" and you want to call it "student_info". We need a command to do this.
The correct answer is Option A: RENAME.
Here's how you would use it:
`RENAME TABLE students TO student_info;`
Let's look at the other options:
Option B: CHANGE is used to modify the definition of a column within a table.
Option C: CHANGENAME and Option D: CHANGENM are not valid MySQL commands.
So, remember that RENAME is your go-to command for renaming tables in MySQL!