Which of the following are some general characteristics of the MEMORY storage engine?

The correct answer is A. Each table is represented on disk as a .frm file. D. They can not contain TEXT or BLOB columns E. Table contents will not be saved if the server is restarted. The MEMORY storage engine manages tables that have the following characteristics: Each MEMORY table is represented on disk by an .frm format file in the database directory. Table data and indexes are stored in memory. In-memory storage results in very fast performance. MEMORY…

Storage Engines

Question

Options

AEach table is represented on disk as a .frm file.
BEach table has a corresponding .MYI and .MYD file.
CThey can support foreign keys.
DThey can not contain TEXT or BLOB columns
ETable contents will not be saved if the server is restarted.
FThey can support transactions.

How the community answered

(33 responses)

A
82% (27)
B
3% (1)
C
6% (2)
F
9% (3)

Explanation

The MEMORY storage engine manages tables that have the following characteristics: Each MEMORY table is represented on disk by an .frm format file in the database directory. Table data and indexes are stored in memory. In-memory storage results in very fast performance. MEMORY table contents do not survive a restart of the server. The table structure itself survives, but the table contains zero data rows after a restart. MEMORY tables use up memory (obviously), so they should not be used for large tables. MySQL manages query contention for MEMORY tables using table-level locking. Deadlock cannot occur. MEMORY tables cannot contain TEXT or BLOB columns.

Topics

#MEMORY storage engine#TEXT BLOB limitation#data persistence#.frm file

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice