ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which storage engine enables to access tables from a MySQL server managed by another server?

Answer & Solution
Correct Answer: Option D
This question is about how MySQL tables can be accessed from different servers. Imagine you have two computers, and you want to use tables from one computer on the other.

The correct answer is Option D: FEDERATED.

Here's why:
* FEDERATED is a special storage engine designed to connect to tables on another MySQL server. Think of it like a bridge between two computers.

Let's look at the other options:
* Option A: InnoDB is a very common storage engine, but it doesn't handle connecting to remote servers.
* Option B: EXAMPLE is not a valid storage engine in MySQL.
* Option C: MyISAM is another popular storage engine, but it also doesn't have the capability to connect to remote servers.

So, if you want to access tables from a different MySQL server, the FEDERATED storage engine is your best choice.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.