Which three statements are characteristic of the MEMORY storage engine?
A.
Each table is represented on disk as an.frm file.
B.
Each table has a corresponding.MYI and .MYD file.
C.
It can support foreign keys.
D.
It cannot contain text or BLOB columns.
E.
Table contents are not saved if the server is restarted.
F.
It can support transactions
Explanation:
Answer is C, D and E.
http://dev.mysql.com/doc/refman/5.6/en/memory-storage-engine.html
After reading the documentation,MEMORY storage doesn’t allow foreign keys.
A,D,E
there is a .frm file for each table.
In :
http://dev.mysql.com/doc/refman/5.6/en/memory-storage-engine.html
Transactions No
Foreign key support No
Support for variable-length data types (including BLOB and TEXT) not supported by MEMORY.
The Answer is A, D, E.
A, D, E. Agreed.
A, D, E
A, D, E Agreed.