Which two code samples demonstrate valid methods for working with loops?

A. DECLARE I INT DEFAULT 0; Test_loop: LOOP SET i =i +1; IF i> =5 THEN LEAVE test_loop; END IF; END LOOP test_loop;

B. DECLARE i INT DEFAULT 0; WHILE I < 5ITERATE SET i = i +1; END WHILE;

C. DECLARE i INT DEFAULT 0; WHILE i < 5 Do SET i = i + 1; END WHILE;

D. DECLARE i INT DEFAULT 0; Test _loop; LOOP SET i =i +1; IF i >=5 THEN LEAVE; END IF; END LOOP test_loop;

Your MYSQL server was successfully running for a days, and then suddenly stopped .You are sure that no

mysqld process is running.

Which two may provide diagnostic information to help determine why the MYSQL server stopped?

A. The general query log file

B. The syslog on Linux/UNIX or the Event view on windows

C. The slow query log file

D. The MYSQL server error log file

E. The binary log file

A table (t1) contains 1000 random integer values in the first column (col1). The random values range from 1 to 1000.

You execute this query: SELECT col1 FROM t1 WHERE col1< 100 UNION SELECT col1 FROM t1 WHERE col1 BETWEEN 100 and 200 UNION ALL SELECT col1 FROM t1 WHERE col 1 >=900

What is the output?

A. A list of unique values within the ranges of 1-200 and 900-1000

B. A list of unique values within the range of 1-200 and a list of all values, including duplicates, on the table within the range of 900-1000

C. A list of all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000

D. A list of all values, including duplicates, in the ranges of 1-200 and 900-1000

E. An error, because mixing UNION and UNION ALL in the same query is not permitted

Given the data from table t1:

This DELETE command is executed: DELETE FROM t1 ORDER BY b.a DESC LIMIT 2; Which set of rows will be deleted by the command?

A. (7,1) and (1,4)

B. (2,8) and (1,4)

C. (7,1) and (10,8)

D. (2,8) and (10,8)

Consider the table structure shown by this output: Mysql> desc city:

5 rows in set (0.00 sec)

You execute this statement:

SELECT -,-, city. * FROM city LIMIT 1

What is returned?

A. An error message

B. One row with 5 columns

C. One row with 10 columns

D. One row with 15 columns