Oracle
1Z0-873 · Question #15
Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table?
The correct answer is C. storage_engine. If you create a table without using an ENGINE option to specify a storage engine explicitly, the MySQL server creates the table using the default engine, which is given by the value of the storage_engine system variable.
JDBC
Question
Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table?
Options
- Adefault_engine
- Bstorage_default
- Cstorage_engine
- Ddefault_storage_engine
How the community answered
(59 responses)- A14% (8)
- B8% (5)
- C75% (44)
- D3% (2)
Explanation
If you create a table without using an ENGINE option to specify a storage engine explicitly, the MySQL server creates the table using the default engine, which is given by the value of the storage_engine system variable.
Topics
#default storage engine#storage_engine variable#MySQL configuration#system variables
Community Discussion
No community discussion yet for this question.