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

Solution (By Examveda Team)

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.