Online Access Free 1z0-882 Practice Test

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;

You have two tables: news_source and news_feed.

Here is some sample data from the news _feed table:

• A.Option A
• B.Option B
• C.Option D
• D.Option C

A SELECT statement without an ORDER BY clause return some rows.
Which statement is always true about the order of the returned results?

• A.The results are in descending order.
• B.The results are in the order inserted.
• C.The results are in ascending order.
• D.The results are not in a set order.

Which two Functions can be used in a C program to retrieve information about warning?

• A.mysql_warning_count
• B.mysql_errno
• C.mysql_info
• D.mysql_error

You have access to a MySQL 5.6 database with the SELECT ,INSERT, and DELETE privileges on all tables in the mydb
database.
The mydb database.
The mydb t1 table has five rows of data.
You use the statement below to remove all rows in the t1 table:
Mysql> TRUNCATE TABLE mysql.t1;
What is the result?

• A.The command succeeds and five rows are affected.
• B.The command succeeds and o rows are affected.
• C.The command fails owing to permissions error.
• D.The command fails owing to syntax error.