최신Oracle Certified Professional, MySQL 5.6 Developer - 1z1-882무료샘플문제
문제1
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?
You attempt to create a temporary table by using the following statement:
CREATE TEMPORARY TABLE employeesMAIN
SELECT * FROM employees1
UNION ALL
SELECT * FROM employees2;
What is the result?
정답: D
문제2
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?
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
문제3
When executing a stored routine, how is the SQL_MODE determined?
When executing a stored routine, how is the SQL_MODE determined?
정답: C
설명: (KoreaDumps 회원만 볼 수 있음)
문제4
You have two test tables:
Code_innodb as InnoDB engine
Code_ myisam as MYISAM engine
The tables have the same structure:
The tables have one row of data:
You execute an INSERT statement on both code_myisam tables and receive duplicate key errors:
mysql> INSERT INTO code_innodb VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie,),(4, 'Delta');
ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'
Mysql> INSERT INTO code_myisam VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie'),
(4, 'Delta');
ERROR 1062 (23000); Duplicate entry '3' for key 'PRIMARY'
What is the expected output of the SELECT statements?
You have two test tables:
Code_innodb as InnoDB engine
Code_ myisam as MYISAM engine
The tables have the same structure:
The tables have one row of data:
You execute an INSERT statement on both code_myisam tables and receive duplicate key errors:
mysql> INSERT INTO code_innodb VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie,),(4, 'Delta');
ERROR 1062 (23000): Duplicate entry '3' for key 'PRIMARY'
Mysql> INSERT INTO code_myisam VALUES (1, 'Alpha'), (2, 'Beta'), (3, 'charlie'),
(4, 'Delta');
ERROR 1062 (23000); Duplicate entry '3' for key 'PRIMARY'
What is the expected output of the SELECT statements?
정답: B
문제5
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 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,C
문제6
You have a database 'dev' that contains 15 tables, all of which use the CHARACTER SET 'utfs' and the COLLATION
'utfs_general_ci'.
You perform the command:
ALTER DATABASE 'dev' CHARACTER SET ='latin' COLLATION='latin1'_swedish_ci'
What is the result?
You have a database 'dev' that contains 15 tables, all of which use the CHARACTER SET 'utfs' and the COLLATION
'utfs_general_ci'.
You perform the command:
ALTER DATABASE 'dev' CHARACTER SET ='latin' COLLATION='latin1'_swedish_ci'
What is the result?
정답: E
문제7
Which two queries return a value of NULL?
Which two queries return a value of NULL?
정답: B,E
문제8
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?
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?
정답: D
문제9
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
Which three statements describe valid reasons why queries that use "SELECT" construct are discouraged?
정답: B,D,E
문제10
You want to use the SHA -256 Authentication plugin with Connector/J.
Which two parameter settings achieve this?
You want to use the SHA -256 Authentication plugin with Connector/J.
Which two parameter settings achieve this?
정답: C