Online Access Free 1z0-882 Exam Questions

Given the data:

Expected output:

Which query produces the expected output?

• A.SELECT colors2.name,colors1.name
  FROM colors2
  RIGHT JOIN colors1
  ON colors2.name=colors1.name
• B.SELECT colors2.name,colors1.name
  FROM colors2
  LEFT JOIN colors1
  ON colors2.name=colors1.name
• C.SELECT colors2.name, colors1.name
  FROM colors2
  STRAIGHT JOIN colors1
  ON colors2.name, =colors1.name
• D.SELECT colors2.name, colors1.name
  FROM colors2
  OPTIONAL JOIN colors1
  ON colors2.name, colors1.name
• E.SELECT colors2.name, colors1.name
  FROM colors2
  NATURAL JOIN colors1
  ON colors2.name=colors1.name

Which statement describes the process of normalizing databases?

• A.Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest
  allocation.
• B.Redundant tables are combined into one larger table to simplify the schema design.
• C.Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
• D.All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
• E.Columns that contain repeating data values are split into separate tables to reduce item duplication.

Consider the stored procedure
CREATE PROCEDURE param_test (
IN P_in INT,
OUT P_out INT,
INPUT P_inout INT)
BEGIN
SELECT P_in, P_out, P_ inout;
SET P_in, P_inout
END
You execute a series of commands:

What is the output of the CALL and SELECT?

• A.(0,NULL,0) and(0,200,300)
• B.(0,0,0) and (0,0,0)
• C.(0,NULL,0) and (100,200,300)
• D.(0,0,0,) and (0,200,300)

Which three statement types can be prepared?

• A.ALTER VIEW
• B.CREATE TABLE
• C.LOAD DATA INFILE
• D.CREATE VIEW
• E.CALL

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 completes, and 15 is returned
• C.An infinite loop will be running until the command is killed.
• D.The procedure's loop is not entered, and 1 is returned.