1z1-882無料問題集「Oracle Certified Professional, MySQL 5.6 Developer」

質問 1

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 D

（B）Option B

（C）Option C

（D）Option A

正解：C 解答を投票する

質問 2

A table country exists with a column Name. A user variable @ limitcount contains the value 20.
Which two statements are valid uses of the LIMIT clause?

（A）SELECT Name FROM country LIMIT 100,50

（B）SELECT Name FROM country LIMIT 100-50

（C）SELECT Name FROM country LIMIT 35

（D）SELECT Name FROM country LIMIT @limitcount

（E）SELECT Name FROM country LIMIT RAND ()

正解：A、C 解答を投票する

質問 3

You attempt to create two new tables:
CREATE TABLE 'warehouse' (
'id' int (11) NOT NULL AUTO_INCREMENT,
'name' varchar (20) NOT NULL,
'phone' varchar (20) NOT NULL,
PRIMARY KEY (' id)
) ENGINE=MyISAM
CREATE TABLE 'warehouseitem' (
'warehouse_id' bigint (11) NOT NULL,
'item_id' int (11) NOT NULL,
'count' int(11) NOT NULL DEFAULT '0',
KEY "warehouse_id' ('warehouse-id) ,
FOREIGN KEY (warehouse_id) REFFERENCES warehouse (id)
) ENGINE= InnoDB
You get this error :
ERROR 1215 ( HYooo): cannot add foreign key constraint
Which two changes are required to permit these statements to execute without any error?

（A）The data types of the 'warehouse'.'id' and ' warehouseitem.warehouse_is columns must match.

（B）The foreign key clause must be reversed: FOREIGN KEY warehouse(1)REFERENCES (warehouse-id).

（C）The 'warehouse-table must be managed by the InnoDB storage engine.

（D）The warehouse_id' column must be renamed 'id' to match the definition on the 'warehouse' table.

（E）The 'warehouseitem' table must be managed by the MySAm storage engine.

（F）A UNIQUE key must be defined for the columns ('item_id','warehouse_id').

正解：A、C 解答を投票する

質問 4

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,NULL,0) and (100,200,300)

（C）(0,0,0) and (0,0,0)

（D）(0,0,0,) and (0,200,300)

正解：A 解答を投票する

質問 5

Which condition must be true in order that a view is considered updateable?

（A）There must be a one-to-one relationship between the rows in the view and the rows in the underlying table.

（B）The user must have the UPDATE or DELETE privilege for the underlying table.

（C）The view must only refer to literal values.

（D）There must be a subquery in the WHERE clause that refers to a table in the FROM clause.

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

The city table has the following structure:

Consider the statement with an incorrect field name:
PREPARE countryBYID FROM 'SELECT country FROM city WHERE ID=?,
What happens if a prepared statement named countryByID already exists when the above statement is executed?

（A）A duplicate name error will result because a prepared statement with the same name already exists.

（B）An unknown column error will result and the old prepared statement definition will remain in effect.

（C）An unknown column error will result and no prepared statement named countryByID will exist.

（D）A warning will result and the old prepared statement definition will remain in effect.

正解：C 解答を投票する

質問 7

The application logs contain many entries of the following:
ERROR 1153 (OSSO1): Got a packet bigger than 'max_allowed_packet' bytes
With two scenarios can (Hibernate this error message?

（A）The application tried to INSERT a row that exceeded max_allowed_packet.

（B）The operating system caused an error inducing the max_allowed_packet error.

（C）The application tried to SELECT a row that exceeded max_allowed_packet.

（D）The application did not use the COMPRESS () function for a large result set.

（E）The application tried to SELECT many rows together that exceeded max__allowed_packet.

（F）The network caused an error Inducing the max_allowed_packet error.

正解：A、F 解答を投票する

質問 8

Which two can be used to obtain information stored in the Diagnostics Area?

（A）GET DIAGNOSTICS CONDITION 1 @errno=MYSQL_ERRNO, @msg =MESSAGE_TEXT;
SELECT @errno, @msg;

（B）SHOW WARNINGS

（C）SHOW GLOBAL STATUS LIKE 'Diagnostics'

（D）SELECT ERRNO, MESSAGE_TEXT FROM INFORMATION_SCHEMA.DIAGNOSTICS_AREA WHERE CONDITION=1

正解：A、B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 9

Using the query:
SELECT Code FROM country WHERE Name = 'united states'
Which statement executed in the mysql client would create a prepared statement?

（A）PREPARE STATEMENT countrycode FROM 'SELECT code FROM counyry WHERE Name =?.;

（B）PREPARE countrycode As 'SELECT code FROM country WHERE Name =?.;

（C）PREPARE countrycode FROM 'SELECT code FROM country WHERE Name =?.;

（D）PREPARE STATEMENT countrycode As 'SELECT code FROM country WHERE Name =?.;

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

Given the data:

Expected output:

Which query produces the expected output?

（A）SELECT colors2.name,colors1.name
FROM colors2
LEFT JOIN colors1
ON colors2.name=colors1.name

（B）SELECT colors2.name,colors1.name
FROM colors2
RIGHT JOIN colors1
ON colors2.name=colors1.name

（C）SELECT colors2.name, colors1.name
FROM colors2
NATURAL 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
STRAIGHT JOIN colors1
ON colors2.name, =colors1.name

正解：B 解答を投票する

1z1-882 無料問題集「Oracle Certified Professional, MySQL 5.6 Developer」

弊社を連絡する

関連リンク

トップ試験