• 2022-06-07 问题

    数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的 A: Select * From Student Where Sex '男' B: Select * From Student Where Sex ='女' C: Select * From Student Where Sex In '男' D: Select * From Student Where Sex ='男'

    数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的 A: Select * From Student Where Sex '男' B: Select * From Student Where Sex ='女' C: Select * From Student Where Sex In '男' D: Select * From Student Where Sex ='男'

  • 2022-06-16 问题

    下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。( ) A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);

    下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。( ) A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);

  • 2022-06-07 问题

    数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?() A: ASelect* From Student Where Sex=’男’ B: BSelect* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’) C: CSelect* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’) D: DSelect* From Student Where Sex<>’男’

    数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?() A: ASelect* From Student Where Sex=’男’ B: BSelect* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’) C: CSelect* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’) D: DSelect* From Student Where Sex<>’男’

  • 2022-06-07 问题

    数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?() A: Select* From Student Where Sex=’男’ B: Select* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’) C: Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’) D: Select* From Student Where Sex<>’男&rsquo

    数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。要求查询所有男同学信息,下列哪个SQL语句是正确的?() A: Select* From Student Where Sex=’男’ B: Select* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’) C: Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’) D: Select* From Student Where Sex<>’男&rsquo

  • 2022-06-06 问题

    下列结构体的定义正确的是( )。 A: student { int num; char name[10]; char sex; }; B: struct student { int num; char name[10]; char sex; } C: struct student { int num; char name[10]; char sex; }; D: struct student { int num char name[10] char sex };

    下列结构体的定义正确的是( )。 A: student { int num; char name[10]; char sex; }; B: struct student { int num; char name[10]; char sex; } C: struct student { int num; char name[10]; char sex; }; D: struct student { int num char name[10] char sex };

  • 2022-06-04 问题

    已知学生基本信息student包括(xuehao学号,姓名name,性别sex,…),将学号为'201011001'学生的姓名改为'张三',同时性别改为'女',正确的SQL语句为:( )。 A: update student set name='张三',sex='女' where xuehao='201011001' B: update student set name='张三'or sex='女' where xuehao='201011001' C: update student set name='张三' sex='女' where xuehao='201011001' D: update student set name='张三' and sex='女' where xuehao='201011001'

    已知学生基本信息student包括(xuehao学号,姓名name,性别sex,…),将学号为'201011001'学生的姓名改为'张三',同时性别改为'女',正确的SQL语句为:( )。 A: update student set name='张三',sex='女' where xuehao='201011001' B: update student set name='张三'or sex='女' where xuehao='201011001' C: update student set name='张三' sex='女' where xuehao='201011001' D: update student set name='张三' and sex='女' where xuehao='201011001'

  • 2022-07-23 问题

    如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT( SNO varchar(4) PRIMARY KEY,SNAME varchar(8),SEX char(2),AGE int CHECK(AGE&gt;15 AND AGE&lt;30))则下面的语句中可以正确执行的是( )。 A: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ’男’, 17) B: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ‘男’, 14) C: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘男’, 20) D: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’,‘安琦’, 16)

    如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT( SNO varchar(4) PRIMARY KEY,SNAME varchar(8),SEX char(2),AGE int CHECK(AGE&gt;15 AND AGE&lt;30))则下面的语句中可以正确执行的是( )。 A: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ’男’, 17) B: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ‘男’, 14) C: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘男’, 20) D: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’,‘安琦’, 16)

  • 2022-06-08 问题

    以下对结构体类型的变量定义中不正确的是 。 A: B: define STUD struct student STUD {long num; char name[20]; char sex; float score;}; STUD stud1,stud2; C: struct student {long num; char name[20]; char sex; float score; }stud1,stud2; D: struct {long num; char name[20]; char sex; float score; } stud1,stud2; E: struct {long num; char name[20]; char sex; float score; }student;struct student stud1,stud2;

    以下对结构体类型的变量定义中不正确的是 。 A: B: define STUD struct student STUD {long num; char name[20]; char sex; float score;}; STUD stud1,stud2; C: struct student {long num; char name[20]; char sex; float score; }stud1,stud2; D: struct {long num; char name[20]; char sex; float score; } stud1,stud2; E: struct {long num; char name[20]; char sex; float score; }student;struct student stud1,stud2;

  • 2022-06-16 问题

    查询学生表中,所有学生的学号(sno),姓名(sname),性别(sex),和生日(birthday),下列select语句正确的是 A: SELECTsno, sname, sex, birthday FROMstudent B: SELECT * FROM student C: SELECTsno, sname, birthday FROM student D: SELECTsno, sname, sex  FROMstudent

    查询学生表中,所有学生的学号(sno),姓名(sname),性别(sex),和生日(birthday),下列select语句正确的是 A: SELECTsno, sname, sex, birthday FROMstudent B: SELECT * FROM student C: SELECTsno, sname, birthday FROM student D: SELECTsno, sname, sex  FROMstudent

  • 2021-04-14 问题

    学生表student包含sname、sex、age三个属性列...age) VALUES(M,Lili);

    学生表student包含sname、sex、age三个属性列...age) VALUES(M,Lili);

  • 1 2 3 4 5 6 7 8 9 10