1z0-882 試験問題を無料オンラインアクセス

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 all values , including duplicates, in the range of 1-200 and a list of unique values in the range of 900-1000
• B.An error, because mixing UNION and UNION ALL in the same query is not permitted
• C.A list of all values, including duplicates, in the ranges of 1-200 and 900-1000
• D.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
• E.A list of unique values within the ranges of 1-200 and 900-1000

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

You want to load data directly from a file into MYSQL by using the SOURCE command.
Which types of data can the file contains to perform this?

• A.Comma-delimited data
• B.Tab-delimited data
• C.SQL commands
• D.MyISAM or InnoDB data files

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 (10,8)
• C.(2,8) and (1,4)
• D.(7,1) and (10,8)

You have created your connector/Net object to connect to MySQL.
What are three valid database operations you can call?

• A.PreformReadonly, performNonQuery,perforIndexRead
• B.Insert Mysql, UpdateMysql,DeleteMysql
• C.ExecuteReader, ExecuteNonQuery, ExecuteScalar
• D.Query, Execute.MySql, Read. Execute. MySQl, Execute,Mysql
• E.Query .Apply ,Mysql.Delete.Mysql,Query. Update .Mysql