최신Oracle Certified Professional, MySQL 5.6 Developer (1z1-882日本語版) - 1z1-882日本語무료샘플문제
문제1
정답: B,D
문제2
정답: C,D,E
문제3
정답: A
문제4
정답: B
설명: (ExamPassdump 회원만 볼 수 있음)
문제5
정답: B,D
설명: (ExamPassdump 회원만 볼 수 있음)
문제6
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'
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'
정답: C
문제7
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
SELECT Name
FROM City
WHERE CountryCode = 'USA" OR WHERE CountryCode= 'JPN'
정답: A
문제8
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';
2 rows in set (0.00 sec)
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date >
'2008-10-11';
2 rows in set (0.00 sec)
정답: B
문제9
정답: A,E
문제10
The affected -rows count
The affected -rows count
정답: B