以下是关于MySQL数据库考试的一些真题:
1. 如何创建一个名为“testdb”的数据库? A. CREATE DATABASE testdb; B. CREATE DB testdb; C. CREATE testdb; D. CREATE SCHEMA testdb; 答案:A 2. 下列哪条SQL语句可以在“students”表中插入一条学生记录,其中姓名为“张三”,性别为“男”,年龄为“18”? A. INSERT INTO students (name, sex, age) VALUES ('张三', '男', 18); B. INSERT INTO students VALUES ('张三', '男', 18); C. INSERT (name, sex, age) INTO students VALUES ('张三', '男', 18); D. INSERT students (name, sex, age) SET name='张三', sex='男', age=18; 答案:A 3. 下面哪个选项可以把“students”表中所有年龄大于18岁的学生的姓名和学号查询出来? A. SELECT name, stu_num FROM students WHERE age>18; B. SELECT name, stu_num FROM students WHERE age=18; C. SELECT name, stu_num FROM students WHERE age=18; 答案:A 4. 下面哪个选项可以将“students”表中学号为“1001”的学生的姓名更新为“李四”? A. UPDATE students SET name='李四' WHERE stu_num=1001; B. UPDATE students SET name='李四' WHERE name='1001'; C. UPDATE schools SET name='李四' WHERE stu_num=1001; D. UPDATE schools SET name='李四' WHERE name='1001'; 答案:A 5. 下面哪个选项可以删除“students”表中年龄小于18岁的学生记录? A. DELETE FROM students WHERE age<18; B. DELETE * FROM students WHERE age<18; C. DELETE ROWS FROM students WHERE age<18; D. DELETE students WHERE age<18; 答案:A
学习了以上内容,大家可以更加深入的了解MySQL数据库的相关知识点,提高自己的MySQL数据库应用技能。