nerdexam
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)
  • A
    78% (14)
  • D
    6% (1)
  • E
    17% (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.

Full 1Z0-873 Practice