• 2022-06-16 问题

    查询Student表中的所有记录的Sname、Ssex和Class列。 A: select Sname,Ssex,Class from student B: show Sname,Ssex,Class from student C: select * from student D: select Sname,Ssex,Class from course

    查询Student表中的所有记录的Sname、Ssex和Class列。 A: select Sname,Ssex,Class from student B: show Sname,Ssex,Class from student C: select * from student D: select Sname,Ssex,Class from course

  • 2022-06-07 问题

    以下创建视图的语句中,正确的是 A: CREATE st_view AS SELECT sid,sname,ssex FROM stu B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu C: CREATE VIEW st_view AS sid,sname,ssex FROM stu D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu

    以下创建视图的语句中,正确的是 A: CREATE st_view AS SELECT sid,sname,ssex FROM stu B: CREATE VIEW st_view SELECT sid,sname,ssex FROM stu C: CREATE VIEW st_view AS sid,sname,ssex FROM stu D: CREATE VIEW st_view AS SELECT sid,sname,ssex FROM stu

  • 2022-06-06 问题

    查询Student表中“95031”班或性别为“女”的同学记录。 A: select * from student when Class=‘95031’ or Ssex=‘女’ B: select * from student where Class=‘95031’ or Ssex=‘女’ C: select * from student where set Class=‘95031’ or Ssex=‘女’ D: select * from student where Class=‘95031’ and Ssex=‘女’

    查询Student表中“95031”班或性别为“女”的同学记录。 A: select * from student when Class=‘95031’ or Ssex=‘女’ B: select * from student where Class=‘95031’ or Ssex=‘女’ C: select * from student where set Class=‘95031’ or Ssex=‘女’ D: select * from student where Class=‘95031’ and Ssex=‘女’

  • 2022-05-28 问题

    ‎从Student表检索年龄小于21岁的男学生信息,最规范的SQL语句是( )。‍ A: Select * From Student Where Ssex='男' Or Sage<'21' B: Select * From Student Where Ssex='男' Or Sage<21 C: Select * From Student Where Ssex=男 And Sage<'21' D: Select * From Student Where Ssex='男' And Sage<21

    ‎从Student表检索年龄小于21岁的男学生信息,最规范的SQL语句是( )。‍ A: Select * From Student Where Ssex='男' Or Sage<'21' B: Select * From Student Where Ssex='男' Or Sage<21 C: Select * From Student Where Ssex=男 And Sage<'21' D: Select * From Student Where Ssex='男' And Sage<21

  • 2022-06-07 问题

    要在student(sno,sname,ssex,sage,sdept)表中,查询全体女生的姓名、年龄,以下正确的查询语句是( )。 A: select * from student where ssex='女' B: select 姓名, 年龄 from student where 性别 ='女' C: select sname , sage from student where ssex='女’ D: select sname 姓名, sage 年龄 from student where ssex='女'

    要在student(sno,sname,ssex,sage,sdept)表中,查询全体女生的姓名、年龄,以下正确的查询语句是( )。 A: select * from student where ssex='女' B: select 姓名, 年龄 from student where 性别 ='女' C: select sname , sage from student where ssex='女’ D: select sname 姓名, sage 年龄 from student where ssex='女'

  • 2022-06-07 问题

    现有学生关系表S(sno,sname,ssex,sage),查找比所有"张三"年龄大的男生信息,下列选项中正确的SQL语句是________。 A: select * fromSwhere ssex='男' and sage>;SOME(select sage from S where sname='张三); B: select * fromSwhere ssex='男' and sage>;ALL(select sage from S where sname='张三); C: select * fromSwhere ssex='男' and sage>;(select max(sage) from S where sname='张三); D: select * fromSwhere ssex='男' and sage>;(select min(sage) from S where sname='张三);

    现有学生关系表S(sno,sname,ssex,sage),查找比所有"张三"年龄大的男生信息,下列选项中正确的SQL语句是________。 A: select * fromSwhere ssex='男' and sage>;SOME(select sage from S where sname='张三); B: select * fromSwhere ssex='男' and sage>;ALL(select sage from S where sname='张三); C: select * fromSwhere ssex='男' and sage>;(select max(sage) from S where sname='张三); D: select * fromSwhere ssex='男' and sage>;(select min(sage) from S where sname='张三);

  • 2022-06-26 问题

    如果有学生表student,ssex代表学生性别,sname代表姓名,则想要得到所有姓张和姓王的女学生信息的SQL语句是() A: SELECT *<br/>FROM student<br/>WHERE ssex='女' OR sname ='张%' AND sname ='王%' B: SELECT *<br/>FROM student<br/>WHERE ssex='女' OR sname like '张%' AND sname like '王%' C: SELECT *<br/>FROM student<br/>WHERE ssex='女' AND (sname like '张%' OR sname like '王%') D: SELECT *<br/>FROM student<br/>WHERE (ssex='女' AND sname like '张%') OR sname like '王%'

    如果有学生表student,ssex代表学生性别,sname代表姓名,则想要得到所有姓张和姓王的女学生信息的SQL语句是() A: SELECT *<br/>FROM student<br/>WHERE ssex='女' OR sname ='张%' AND sname ='王%' B: SELECT *<br/>FROM student<br/>WHERE ssex='女' OR sname like '张%' AND sname like '王%' C: SELECT *<br/>FROM student<br/>WHERE ssex='女' AND (sname like '张%' OR sname like '王%') D: SELECT *<br/>FROM student<br/>WHERE (ssex='女' AND sname like '张%') OR sname like '王%'

  • 2022-06-05 问题

    查询每个学生及其选修课程的情况(不包括没有选修课程的学生),以下语句正确的为()(SQLSERVER平台中) A: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightjoinscon(student.sno=sc.sno) B: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentleftjoinscon(student.sno=sc.sno) C: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightoutjoinscon(student.sno=sc.sno) D: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM scleft outjoin Studenton(student.sno=sc.sno)

    查询每个学生及其选修课程的情况(不包括没有选修课程的学生),以下语句正确的为()(SQLSERVER平台中) A: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightjoinscon(student.sno=sc.sno) B: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentleftjoinscon(student.sno=sc.sno) C: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightoutjoinscon(student.sno=sc.sno) D: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM scleft outjoin Studenton(student.sno=sc.sno)

  • 2022-06-16 问题

    查询Student表中的所有记录的Sname、Ssex和Class列。

    查询Student表中的所有记录的Sname、Ssex和Class列。

  • 2021-04-14 问题

    假设表Students中的SEMail列的默认值为“SVE@163.com”,同时还有SAddress列和SSex列, 则执行T-SQL: INSERT Students(SAddress, SSex) VALUE('SVE', 1) 下列说法中正确的选项是()

    假设表Students中的SEMail列的默认值为“SVE@163.com”,同时还有SAddress列和SSex列, 则执行T-SQL: INSERT Students(SAddress, SSex) VALUE('SVE', 1) 下列说法中正确的选项是()

  • 1 2 3 4 5 6 7 8 9 10