Oracle
1Z0-873 · Question #14
When choosing a storage engine for each of your tables, which things are to consider?
The correct answer is A. Locking Characteristics: Some storage engines lock on row level, some on page level, some on B. Transactions support: Some storage engines support transactions, some don't. C. Storage media: Some storage engines store data on disk, some in memory. Point in time recovery is not a feature of a storage engine.
JDBC
Question
When choosing a storage engine for each of your tables, which things are to consider?
Options
- ALocking Characteristics: Some storage engines lock on row level, some on page level, some on
- BTransactions support: Some storage engines support transactions, some don't.
- CStorage media: Some storage engines store data on disk, some in memory.
- DLicenses: Some storage engines cannot be used in commercial environments, others can.
- EBackup methods: Some storage engines support online backup and point in time recovery, some
How the community answered
(18 responses)- A78% (14)
- D6% (1)
- E17% (3)
Explanation
Point in time recovery is not a feature of a storage engine.
Topics
#storage engine selection#transactions#locking characteristics#MySQL
Community Discussion
No community discussion yet for this question.