举一反三
- 表student中的包含两个字段，整型的id，字符串型的name。只显示表student中name列记录的SQL语句正确的是（） A: select name from student B: select * from student C: select from name in student D: select name
- Student类中存在String类型name属性,下列Student类的构造方法中,哪个是正确的？ A: Student(String name){} B: Student(String name) C: Student(name)() D: NewStudent (String name){}
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;
- 若想查询student表中name为空值的记录，则正确的SQL语句是（1.0分） A: select * from student where name = null; B: select * from student where name link null; C: select * from student where name = 'null'; D: select * from student where name is null;
- 修改表Student中姓名Name为“张三”的学生的专业Major改为“计算机” A: ALTER TABLE Student SET Name='张三' WHERE Major='计算机' B: UPDATE Student SET Name='张三' WHERE Major='计算机' C: UPDATE Student SET Major='计算机' WHERE Name='张三' D: ALTER TABLE Student SET Major='计算机' WHERE Name='张三'
内容
- 0
已知 student 表有姓名字段 name ,并且存在 name 为’sun%er’的记录。下列选项中,以匹配“ sun%er ”字段值的 SQL 语句是 A: SELECT * FROM student WHERE name LIKE ‘sun%er’; B: SELECT * FROM student WHERE name LIKE ‘%%%’; C: SELECT * FROM student WHERE name LIKE '%\%%'; D: SELECT * FROM student WHERE name =‘sun%er’;
- 1
已知 student 表有姓名字段 name。若想查询所有姓“王”的学生,并且姓名由三个字符组成,则应使用的SQL 语句是 A: SELECT* FROM student WHERE name LIKE ‘王__’; B: SELECT* FROM student WHERE name LIKE ‘王%_’; C: SELECT* FROM student WHERE name LIKE ‘王%’; D: SELECT* FROM student WHERE name =’王__’;
- 2
下面哪一个是JSON数据？（） A: ｛name："xiaoming"，age，"student"｝ B: ｛"name"："xiaoming"，"age"："student"｝ C: ｛"xiaoming"，"student"｝ D: ["xiaoming"，"student"]
- 3
下列选项中，采用指定表的字段名的方式向表Student中添加id为1，name为”小王”的记录值的SQL语句是"( ) A: INSERT INTO Student(“id”,”name”) VALUES(1,”小王”); B: INSERT INTO Student(id,name) VALUES(1,’小王’); C: INSERT INTO Student VALUES(1,”小王”); D: INSERT INTO Student(id,”name”) VALUES(1,”小王”);
- 4
查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是() A: SELECT name FROM student WHERE id<;5 OR gender='女'; B: SELECT name FROM student WHERE id<;5 AND gender='女'; C: SELECT name FROM student WHERE id<;5 ,gender='女'; D: SELECT name FROM student WHERE id<;5 AND WHERE gender='女';