When relocating an individual table, the table to be relocated should be . . . . . . . .
A. MyISAM
B. InnoDB
C. TRANSACTION
D. ENGINE
Answer: Option A
Solution(By Examveda Team)
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.
Join The Discussion