Oracle 1z0-882 actual dump : Oracle Certified Professional, MySQL 5.6 Developer

You create a table and a stored procedure:
CREATE TABLE t1 (f1 int);
INSERT INTO t1 VALUES (1), (2) , (3), (4), (5);
CREATE PROCEDURE sum_t1()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE va1 INT;
DECLARE result CURSOR FOR SELECT f1 FROM t1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;
REPEAT
FETCH cur INTO va1;
IF NOT done THEN
SET result = result +va1;
END IF:
UNTIL done END REPEAT;
SELECT result;
END
CALL sum_t1();
What is the result of the CALL statement?

• A. The procedure's IF condition is not satisfied, and 0 is returned.
• B. The procedure's loop is not entered, and 1 is returned.
• C. An infinite loop will be running until the command is killed.
• D. The procedure completes, and 15 is returned

Examine the fruit and wine tables:
Fruit

You execute this query:
SELECT fruited, fruitname FROM fruit
UNION
SELECT id, name, country FROM wine;
What is the result?

• A. The query succeeds and returns five columns of data.
• B. The query falls because UNION does not work on tables with different number of columns.
• C. The query succeeds and returns two columns of data.
• D. The query falls because the number of columns in the SELECT in the SELECT clauses are not equal.

You want to use the SHA -256 Authentication plugin with Connector/J.
Which two parameter settings achieve this?

• A. Authenticationplugins=com.mysql.jdbl.jdbc.authentication.sha256passwordplugin,com.mysql.jdbc
• B. defaultAuthenticationplugin=com.mysql.jdbc.authentication.MysqlNativepasswordplugin
• C. Authenticationplugins=com,mysql,authentication,mysqlNativepasswordplugin
• D. defaultAuthenticationplugin=com.mysql.jdbc.authentication.sha256passwordplugin

You have two tables:
CREATE TABLE department (
Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY,
Department _Name varchar(12) NOT NULL
) ENGINE=InnoDB
CREATE TABLE employee (
Employee_Number int unsigned NOT NULL PRIMARY KEY,
Employee_Name varchar(10) NOT NULL,
Department_ID int unsigned DEFAULT NULL,
FOREIGN KEY (Department ID) REFERENCES Department (Department_ID)
ON UPDATE SET NULL ON DELETE CASCADE
)ENGINE= InnoDB
The tables have the data:
Department

You execute the statement:
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
What data is in the employee table after the statement?

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

Which two statements provide the definition for a view named view1 in the test database?

• A. SHOW DEFINITION FOR test.view
• B. SELECT DEFINITION
  FROM INFORMATION_SCHEMA.VIEWS
  WHERE NAME = "test"
• C. SHOW CREATE VIEW test-view1
• D. SHOW CREATE VIEW view1 FROM test
• E. SELECT VIEW_DEFINITION_SCHEMA.VIEWS
  FROM INFORMATION _SCHEMA.VIEWS
  WHERE TABLE_NAME="view1"
  AND TABLE_SCHEMA = "test"