Which of the following statements are true for tables using the FEDERATED storage engine?

The correct answer is A. Each FEDERATED table is represented on disk by a .frm format file in the database directory of C. The FEDERATED storage engine does not support transactions. E. The FEDERATED storage engine supports SELECT statements. F. The FEDERATED storage engine supports DELETE, UPDATE, and INSERT statements. The FEDERATED storage engine manages tables that have the following characteristics: Each FEDERATED table is represented on disk only by an .frm format file in the database The FEDERATED storage engine does not support transactions. The FEDERATED storage engine supports SELECT…

MySQL Storage Engines

Question

Options

AEach FEDERATED table is represented on disk by a .frm format file in the database directory of
BFor each FEDERATED table, the content of the referenced table is stored in a .FED file on the
CThe FEDERATED storage engine does not support transactions.
DThe FEDERATED storage engine supports transaction if the storage engine of the referenced
EThe FEDERATED storage engine supports SELECT statements.
FThe FEDERATED storage engine supports DELETE, UPDATE, and INSERT statements.

How the community answered

(53 responses)

A
75% (40)
B
17% (9)
D
8% (4)

Explanation

The FEDERATED storage engine manages tables that have the following characteristics: Each FEDERATED table is represented on disk only by an .frm format file in the database The FEDERATED storage engine does not support transactions. The FEDERATED storage engine supports SELECT, DELETE, UPDATE, and INSERT statements. MySQL does not use any locking for FEDERATED tables.

Topics

#FEDERATED storage engine#transactions#SELECT support#DML support

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice