Oracle Certified Professional, MySQL 5.6 Developer (1z1-882日本語版) - 1z1-882日本語 Exam Practice Test
Inspect the CREATE TABLE below:
Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;
Query Ok, 0 rows affected, 2 warnings (0.11 sec)
Mysql> SHOW WARNINGS;
Mysql> CREATE TABLE foo (a INT, PRIMARY KEY (a)) ENGINE =InnoDB;
Query Ok, 0 rows affected, 2 warnings (0.11 sec)
Mysql> SHOW WARNINGS;
Correct Answer: C,E
Vote an answer
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
1636 Carsten Pederson Denmark
4672 Kai Voigt Germany
4628 Max Mether France
Mysq1> DESCRIBE people;
Correct Answer: D
Vote an answer
CREATE TRIGGER City_bi
BEFORE INSERT ON CITY
FOR EACH ROW
BEGIN
IF OLD. District IS NULL OR OLD.District= . .
THEN
SET NEW.District='Unknown';
END IF :
END;
Correct Answer: C
Vote an answer
CREATE TABLE t1 (
id int unsigned NOT NULL PRIMARY key) ENGINE = InnoDB;
There are two connections to the server. They execute in this order:
Connection 1> SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Connection 1> START TRANSACTION;
Connection 1> SELECT * FROM t1 WHERE id =1;
Connection 2> TRUNCATE TABLE t1;
Correct Answer: D
Vote an answer
