最新的Oracle Certified Professional, MySQL 5.6 Developer (1z0-882日本語版) - 1z0-882日本語免費考試真題
問題1
Expected output:
正確答案: E
問題2
正確答案: D
問題3
CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES ('pluto'):
正確答案: C
問題4
正確答案: C
問題5
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
Department
REPLACE INTO department (Department_ID, Department_Name) VALUES (1, 'Admin');
正確答案: C
問題6
正確答案: A
問題7
mysql >DESCRIBE country;
mysql> DESCRIBE countrylanguage;
正確答案: B
問題8
DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;
正確答案: D
問題9
Class
正確答案: A,C,E
問題10
正確答案: C
