Inspect the CREATE TABLE below: Mysql CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2 warnings (0.11 sec) Mysql SHOW WARNINGS; Which two is true connecting the meaning of the warnings?

Question

Inspect the CREATE TABLE below:

Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2 warnings (0.11 sec) Mysql> SHOW WARNINGS; Which two is true connecting the meaning of the warnings?

Accepted Answer

D. MYSQL server was not started with the option default -storage -engine=InnoDB E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB

Answer

A. The InnoDB storage engine was disabled during server startup.

Answer

B. Global variable skip _innodb was set to ON after the server had started.

Answer

C. The default storage engine MYISAM was used for the table created.

Inspect the CREATE TABLE below: Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB; Query Ok, 0 rows affected, 2 warnings (0.11 sec) Mysql> SHOW WARNINGS; Which two is true connecting…

Question

Options

How the community answered

Community Discussion