1z1-882 무료 덤프문제 온라인 액세스

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,0,0,) and (0,200,300)
• B.(0,NULL,0) and (100,200,300)
• C.(0,NULL,0) and(0,200,300)
• D.(0,0,0) and (0,0,0)

Which statement is true about the difference between HASH and BTREE INDEXES?

• A.HASH indexes can be used by the optimizer to speed up ORDER BY operations and not BTREE indexes.
• B.HASH indexes are much faster than BTREE indexes but can only be used for a single column.
• C.HASH indexes are used only for equality comparisons (= or<=>),whereas BTREE indexes can also be used for range
  searches (>or<).
• D.HASH indexes support rightmost prefixing of keys, which makes them faster than BTREE indexes in many causes.

A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown:

You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN.
What is the effect of adding STRAIGHT JOINs to the query?

• A.The optimizer processes only the JOINs in the sequence listed in the query.
• B.The optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.
• C.The optimizer will only JOIN the tables in sequence from smallest to largest.
• D.The optimizer ignores all terms in the WHERE clause until all JOINs have been completed.

Given the table City:
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
What does this statement procedure?

• A.A single result set with one column that contains the names of cities from country codes USA and JPN.
• B.A single result set with two columns containing the names from country codes USA and JPN.
• C.Two result sets each containing a single column with the names of cities from country codes USA and JPN.
• D.No result set is returned and an error message is given.

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 JOIN colors2
  on colors1 .name =colors2.name
  GROUP BY colors1.name;
  SELECT colors1.name, count (colors2.name)
  FROM colors1
  RIGHT JOIN colors1
  on colors1 .name =colors2.name
  GROUP BY colors1.name;
• B.SELECT colors1. Name count (colors2.name)
  FROM colors1
  INNER JOIN colors2
  on colors1. Name =colors2. Name
  GROUP BY colors1 .name;
• C.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,
• D.SELECT colors1.name, count(colorse2. Name)
  FROM colorse1 .name =colors2.name
  WHERE colors1. Name =colors2.name
  GROUP BY colors1.name,