MySQL 5.6 Developer: 1Z0-882

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

You have two lists of values to correlate.

Which query lists all names in colors1 and how many total matches are there in colors2?

A. SELECT colors1 .name.count (colors2.name) FROM colors1. Colors2 WHERE Colors1. Name = (SELECT DISTINCT name FROM colors2 WHERE colors1.name=colors2.name) GROUP BY colorse1.name,

B. SELECT colors1.name, count(colorse2. Name) FROM colorse1 .name =colors2.name WHERE colors1. Name =colors2.name GROUP BY colors1.name,

C. SELECT colors1. Name count (colors2.name) FROM colors1 INNER JOIN colors2 on colors1. Name =colors2. Name GROUP BY colors1 .name;

D. SELECT colors1.name, count (colors2.name) FROM JOIN colors2 on colors1 .name =colors2.name GROUP BY colors1.name;

E. SELECT colors1.name, count (colors2.name) FROM colors1 RIGHT JOIN colors1 on colors1 .name =colors2.name GROUP BY colors1.name;

Assume the user has just connected to the MySQL server. What is the result of the query SELECT @ a?

A. An error that @ a is undefined

B. A single NULL

C. An empty string

D. The value of GLOBAL variable @ a