第2题
A.
B.
C.
D.
E.
第3题
A.INSERT INTO employees VALUES (NULL, ‘John‘, ‘Smith‘);
B.INSERT INTO employees(first_name, last_name) VALUES(‘John‘, ‘Smith‘);
C.INSERT INTO employees VALUES (‘1000‘, ‘John‘, NULL);
D.INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, ‘John‘, ‘Smith‘);
E.INSERT INTO employees (employee_id) VALUES (1000);
F.INSERT INTO employees (employee_id, first_name, last_name) VALUES (1000, ‘John‘, ‘ ‘);
第5题
A. INSERT INTO employees VALUES (NULL, ‘John‘, ‘smith‘);
B. INSERT INTO employees (first_name, last_name) VALUES (‘John‘, ‘smith‘);
C. INSERT INTO employees VALUES (‘1000, ‘John‘, ‘smith‘);
D. INSERT INTO employees (first_name, last_name, employee_id) VALUES (1000, ‘John‘, ‘smith‘);
E. INSERT INTO employees (employee_id) VALUES (1000);
F. INSERT INTO employees (employee_id, first_name, last_name, ) VALUES (1000, ‘John‘,‘‘);
第7题
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. The data in the EMPLOYEES table is deleted but not the structure.
D. You get an error because the statement is not syntactically correct.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!