Which three methods will show the storage engine for the Country table?
A.
SHOW CREATE TABLE Country;
B.
SHOW ENGINE Country STATUS;
C.
SHOW TABLE STATUS LIKE ‘Country’;
D.
SELECT ENGINE
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME= ‘Country’;
E.
SELECT ENGINE
FROM INFORMATION_SCHEMA.ENGINES
WHERE TABLE_NAME= ‘Country’;
Explanation:
A,C,D
Answer are:
A, C and D.
B:
mysql> show engine ze status;
ERROR 1286 (42000): Unknown storage engine ‘ze’
The name Table is considered Engine.
E:
mysql> select engine from information_schema.ENGINES where table_name = ‘processlist’;
ERROR 1054 (42S22): Unknown column ‘table_name’ in ‘where clause’
Column table_name is not exist in table Engines from information_schema.
A,C,D
A, C, D
For sure, A, C & D
A,C,D