Oracle Certified Professional, MySQL 5.6 Developer (1z0-882日本語版) - 1z0-882日本語 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Code_innodb as InnoDB engine
Code_ myisam as MYISAM engine

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'

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: B Vote an answer

Question 2

A. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation B. SELECT UPPER (BINARY location) as location FROM MemberLocation C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation D. SELECT UPPER (Location) as location FROM MemberLocation

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 3

Class

A. SELECT *
FROM class
INNER JOIN student
ON class.class_id=student.class_id B. SELECT *
FROM student
RIGHT JOIN class
ON class.class_id=student.class_id C. SELECT *
FROM JOIN student
On class .class_id=student.class_id
WHERE NOT ISNULL (student.class_id) D. SELECT *
FROM class
INNER JOIN student
WHERE NOT ISNULL (student.class_id) E. SELECT *
FROM JOIN student
LEFT JOIN student
ON class. Class.class_id=student.class_id

Discussion 0

Correct Answer: B,C,E Vote an answer

Question 4

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: B Vote an answer

Question 5

Mysql> SELECT * FROM friends;

SELECT AVG (age) FROM friends

A. 20 B. NULL C. 10 D. 0

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 6

The affected -rows count

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: C Vote an answer

Question 7

Mysql> drop function foo;
ERROR 1305 (420000): FUNCTION test, foo does not exist
Mysql > show warnings;

Mysql> get diagnostics condition 2 @msg=MESSAGE_TEXT;

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: A Vote an answer

Question 8

SELECT col1 FROM t1 WHERE col1 <=100 UNION
SELECT col1 FROM t1 WHERE col1 >=900 ORDER BY col1 DESC

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

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();

A. Option B B. Option A C. Option C D. Option D

Discussion 0

Correct Answer: B Vote an answer

Question 10

A. Option B B. Option E C. Option A D. Option C E. Option D

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).