Examveda

The statement used to change the table name is . . . . . . . .

A. RENAME

B. CHANGE

C. CHANGENAME

D. CHANGENM

Answer: Option A

Solution (By Examveda Team)

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!

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous