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?
A. The InnoDB storage engine was disabled during server startup.
B. Global variable skip _innodb was set to ON after the server had started.
C. The default storage engine MYISAM was used for the table created.
D. MYSQL server was not started with the option default storage engine=InnoDB
E. Needed to specify TYPE = InnoDB instead of ENGINE=InnoDB
|
Download Printable PDF. VALID exam to help you PASS. |
 |
A, C