Oracle
1Z0-883 · Question #109
Which three statements are characteristic of the MEMORY storage engine?
The correct answer is 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. See the full explanation below for the reasoning.
Question
Which three statements are characteristic of the MEMORY storage engine?
Options
- AEach table is represented on disk as an.frm file.
- BEach table has a corresponding.MYI and .MYD file.
- CIt can support foreign keys.
- DIt cannot contain text or BLOB columns.
- ETable contents are not saved if the server is restarted.
- FIt can support transactions
How the community answered
(15 responses)- A7% (1)
- B13% (2)
- C73% (11)
- F7% (1)
Community Discussion
No community discussion yet for this question.