资源描述
2025年高职数据库编程(MySQL查询语句)试题及答案
(考试时间:90分钟 满分100分)
班级______ 姓名______
第I卷(选择题 共30分)
(总共6题,每题5分,每题只有一个正确答案,请将正确答案填写在括号内)
w1. 要从名为“students”的表中查询出所有姓“王”的学生记录,正确的SQL语句是( )
A. SELECT FROM students WHERE name LIKE '王%';
B. SELECT FROM students WHERE name = '王%';
C. SELECT FROM students WHERE name LIKE '%王';
D. SELECT FROM students WHERE name = '%王';
w2. 若要查询“students”表中年龄在18到20岁之间的学生信息,以下SQL语句正确的是( )
A. SELECT FROM students WHERE age BETWEEN 18 AND 20;
B. SELECT FROM students WHERE age >= 18 AND age <= 20;
C. 以上两种都正确
D. 以上两种都错误
w3. 要从“orders”表中查询出订单金额大于1000的订单信息,并按订单金额降序排列,SQL语句为( )
A. SELECT FROM orders WHERE amount > 1000 ORDER BY amount DESC;
B. SELECT FROM orders WHERE amount > 1000 ORDER BY amount ASC;
C. SELECT FROM orders WHERE amount >= 1000 ORDER BY amount DESC;
D. SELECT FROM orders WHERE amount >= 1000 ORDER BY amount ASC;
w4. 若要查询“products”表中产品名称包含“手机”的产品信息,SQL语句是( )
A. SELECT FROM products WHERE product_name LIKE '%手机%';
B. SELECT FROM products WHERE product_name = '%手机%';
C. SELECT FROM products WHERE product_name LIKE '手机%';
D. SELECT FROM products WHERE product_name LIKE '%手机';
w5. 要从“employees”表中查询出职位为“经理”的员工姓名和工资,SQL语句为( )
A. SELECT name, salary FROM employees WHERE position = '经理';
B. SELECT name, salary FROM employees WHERE position LIKE '经理';
C. SELECT FROM employees WHERE position = '经理';
D. SELECT FROM employees WHERE position LIKE '经理';
w6. 若要查询“customers”表中客户所在城市为“北京”或“上海”的客户信息,SQL语句正确的是( )
A. SELECT FROM customers WHERE city = '北京' OR city = '上海';
B. SELECT FROM customers WHERE city IN ('北京', '上海');
C. 以上两种都正确
D. 以上两种都错误
第II卷(非选择题 共70分)
w7. (10分)现有“books”表,包含字段:book_id(图书编号)、book_name(图书名称)、price(价格)、author(作者)。请写出SQL语句查询出价格大于50元的图书信息,并按价格升序排列。
w8. (15分)“students”表包含字段:student_id(学生编号)、name(姓名)、age(年龄)、gender(性别)。请写出SQL语句查询出年龄大于20岁的男生信息。
w9. (15分)“products”表有字段:product_id(产品编号)、product_name(产品名称)、category(类别)、price(价格)。请写出SQL语句查询出类别为“电子产品”且价格小于1000元的产品信息。
阅读以下材料,回答问题
材料:“orders”表结构如下:order_id(订单编号)、customer_id(客户编号)、order_date(订单日期)、total_amount(订单总金额)。
w10. (20分)请写出SQL语句查询出2025年1月1日之后的订单信息,并按订单总金额降序排列。
w11. (20分)请写出SQL语句查询出订单总金额大于2000元的客户编号及对应的订单总金额,并按订单总金额升序排列。
答案:
w1. A
w2. C
w3. A
w4. A
w5. A
w6. C
w7. SELECT FROM books WHERE price > 50 ORDER BY price ASC;
w8. SELECT FROM students WHERE age > 20 AND gender = '男';
w9. SELECT FROM products WHERE category = '电子产品' AND price < 1000;
w10. SELECT FROM orders WHERE order_date > '2025-01-01' ORDER BY total_amount DESC;
w11. SELECT customer_id, total_amount FROM orders WHERE total_amount > 2000 ORDER BY total_amount ASC;
展开阅读全文