Oracle
1Z0-873 · Question #16
Which of the following methods can be used to determine the storage engine of your table named "Country"?
The correct answer is A. SHOW CREATE TABLE Country C. SHOWTABLE STATUS LIKE 'Country' D. SELECT ENGINEFROM INFORMATION_SCHEMA.TABLESWHERE TABLE_NAME = 'Country'. See the full explanation below for the reasoning.
Question
Which of the following methods can be used to determine the storage engine of your table named "Country"?
Options
- ASHOW CREATE TABLE Country
- BSHOW STORAGE ENGINE Country
- CSHOWTABLE STATUS LIKE 'Country'
- DSELECT ENGINEFROM INFORMATION_SCHEMA.TABLESWHERE TABLE_NAME = 'Country'
How the community answered
(36 responses)- A83% (30)
- B17% (6)
Community Discussion
No community discussion yet for this question.