Vidyalelo
MySQL · Q506

MySQL

Programming · MySQL · question 506

Q506

When relocating an individual table, the table to be relocated should be . . . . . . . .

A.
MyISAM
Answer
B.
InnoDB
C.
TRANSACTION
D.
ENGINE

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about moving a table in a MySQL database. Think of it like moving a file on your computer.

To move a table, you need to know what type of table it is. The type of table is determined by its "ENGINE". The ENGINE tells MySQL how to store and manage the data in the table.

So, the answer to this question is Option D: ENGINE.

The other options are not relevant to relocating a table:

* Option A: MyISAM and Option B: InnoDB are types of storage engines, but they don't directly relate to the process of relocation.
* Option C: TRANSACTION is a feature of some storage engines (like InnoDB) that helps with data consistency, but it's not directly related to moving a table.