Which three methods will show the storage engine for the Country table?

Which three methods will show the storage engine for the Country table?

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:



Leave a Reply 6

Your email address will not be published. Required fields are marked *


Jose Wilson

Jose Wilson

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.

dash-68

dash-68

For sure, A, C & D