下列语句中，（）不是表数据的基本操作语句。
CREATE 语句
INSERT 语句
DELETE 语句
UPDATE 语句
向数据表中插入一条记录，用以下哪一项命令（）
CREATE
INSERT
SAVE
UPDATE
以下插入数据的语句错误的是（ ）。
INSERT 数据表名 VALUE(值列表);
INSERT INTO 数据表名 VALUES(值列表);
INSERT 数据表名 VALUES(值列表);
INSERT 数据表名 (值列表);
下列选项中，向数据表Student中添加id为1，name为小王的SQL语句正确是( )。
INSERT INTO Student(“id”,“name”) VALUES(1,“小王”);
INSERT INTO Student(id,name) VALUES(1,“小王”);
INSERT INTO Student VALUES(1,小王);
INSERT INTO Student(id,“name”) VALUES(1,“小王”);
下面关于删除数据表记录的SQL语句，正确的是（ ）。
DELETE student ,where id=11;
DELETE FROM student where id=11;
DELETE INTO student where id=11;
DELETE student where id=11;
下列选项中，关于UPDATE语句的描述，正确的是( )
UPDATE只能更新表中的部分记录
UPDATE只能更新表中的全部记录
UPDATE语句更新数据时可以有条件的更新记录
以上说法都不对
下列关于更新数据的SQL语句中，正确的是( )
UPDATE user SET id = u001 ;
UPDATE INTO user SET id = ‘u001’, username=‘jack’;
UPDATE user(id,username) VALUES(‘u001’,‘jack’);
UPDATE user SET id=‘u001’,username=‘jack’;
在MySQL中可以使用INSERT或( )语句，向数据库中一个已有的表插入一行或多行数据。
在MySQL中可以使用（ ）语句来修改、更新一个表或多个表中的数据。
查询选修了“数学”课程的学生姓名，正确的子查询是？
SELECT name FROM students WHERE course = '数学'
SELECT name FROM students WHERE id IN (SELECT sid FROM courses WHERE name='数学')
SELECT name FROM students WHERE id = (SELECT sid FROM courses)
SELECT name FROM students HAVING sid IN (SELECT sid FROM courses)
找出工资高于所有部门平均工资的员工，应使用？
SELECT name FROM employees WHERE salary > AVG(salary)
SELECT name FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY dept)
SELECT name FROM employees WHERE salary > (SELECT MAX(salary) FROM employees)
SELECT name FROM employees WHERE salary > SOME (SELECT salary FROM employees)
查询没有订单的客户，适合使用的子查询关键字是？
IN
EXISTS
ANY
ALL
以下哪个查询等价于WHERE age > ANY (SELECT age FROM students)？
WHERE age > MIN(age)
WHERE age > MAX(age)
WHERE age > (SELECT MIN(age) FROM students)
WHERE age > (SELECT MAX(age) FROM students)
查询和“张三”在同一部门的员工，错误的是？
SELECT * FROM employees WHERE dept = (SELECT dept FROM employees WHERE name='张三')
SELECT * FROM employees WHERE dept IN (SELECT dept FROM employees WHERE name='张三')
SELECT * FROM employees e1 WHERE EXISTS (SELECT * FROM employees e2 WHERE e1.dept=e2.dept AND e2.name='张三')
SELECT * FROM employees WHERE dept LIKE (SELECT dept FROM employees WHERE name='张三')
以下查询的含义是？
查询价格最高的商品
查询价格高于平均价的商品
查询价格高于所有商品价格的商品
查询价格最低的商品
使用EXISTS的子查询通常需要满足什么条件？
主查询和子查询通过字段关联
子查询必须返回多行结果
子查询必须使用聚合函数
主查询必须包含GROUP BY
查询比市场部（'Market'）所有员工工资都高的员工，正确的是？
SELECT * FROM employees WHERE salary > (SELECT salary FROM employees WHERE dept='Market')
SELECT * FROM employees WHERE salary > ALL (SELECT salary FROM employees WHERE dept='Market')
SELECT * FROM employees WHERE salary > ANY (SELECT salary FROM employees WHERE dept='Market')
SELECT * FROM employees WHERE salary > (SELECT SUM(salary) FROM employees WHERE dept='Market')
以下哪个场景适合用NOT IN子查询？
查找有订单的客户
查找订单金额超过1000的客户
查找从未下过订单的客户
查找订单数量最多的客户
查询有订单的客户姓名，正确的SQL语句是？
SELECT name FROM customers WHERE id IN (SELECT cust_id FROM orders)
SELECT name FROM customers c WHERE EXISTS (SELECT 1 FROM orders o WHERE c.id = o.cust_id)
SELECT name FROM customers WHERE id = ANY (SELECT cust_id FROM orders)
SELECT name FROM customers WHERE id = ALL (SELECT cust_id FROM orders)