有如下用户定义类型及操作语句： Tyoe Student SNo As String Sname As String SAge As Integer End Type Dim Stu As Student With Stu SNo=”200609001” SName=”陈果果“ A ge=19 End With 执行MsgBox Stu,Age 后，消息框输出结果是 【13】
有如下用户定义类型及操作语句： Tyoe Student SNo As String Sname As String SAge As Integer End Type Dim Stu As Student With Stu SNo=”200609001” SName=”陈果果“ A ge=19 End With 执行MsgBox Stu,Age 后，消息框输出结果是 【13】
相关考题：
（ 13 ）有如下用户定义类型及操作语句：Type StudentSNo As StringSName As StringSAge As IntegerEnd TypeDim Stu As StudentWith Stu． SNo ＝ "200609001 ”.SName ＝ ” 陈果果 ”.Age 二 19End With执行 MsgBox Stu.Age 后，消息框输出结果是 【 13 】 。
在学生选课数据库中有学生表student（sno,sname,ssex,sage,sdept)，课程表course（cno,cname)及学生选课表sc（sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下哪条语句可以实现查询选了课的学生人数（）。A．select count(*) from scB．select count(sno) from scC．select count(distinct sno) from scD．select count(cno) from sc
以下（）操作实现了student表与sc之间的自然连接。A．select student.* , sc.* from student , sc where student.sno=sc.snoB．select student.* , cno, grade from student , sc where student.sno=sc.snoC．select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.snoD．select student.* , cno, grade from student join sc on student.sno=sc.sno
8、在学生选课数据库中有学生表student（sno,sname,ssex,sage,sdept)，课程表course（cno,cname)及学生选课表sc（sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下哪条语句可以实现查询选了课的学生人数（）。A．select count(*) from scB．select count(sno) from scC．select count(distinct sno) from scD．select count(cno) from sc
将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是（)。A．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.SnoB．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.SnoC．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.SnoD．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
【单选题】将学生选课系统中的学生表student（sNO,sName,sSex,sAge,sCard）的学号列设置为主键列，正确的语句是（）。A．alter table student add primary key on (sNO);B．alter table student add foreign key (sNO);C．alter table student add primary key (sNO);D．alter table student add primary key sNO;
9、将SC和Student表连接起来，显示学生的学号、姓名、课程号、考试分数，不正确的SQL语句是（)。A．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.SnoB．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.SnoC．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.SnoD．Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno
【单选题】为学生选课系统中的学生表student（sNO,sName,sSex,sAge,sCard)的姓名列添加非空约束，正确的语句是（）。A．alter table student add sName varchar(10) not null;B．alter table student modify sName varchar(10) not null;C．alter table student update sName varchar(10) not null;D．alter table student add not null (sName);
以下（）操作实现了student表与sc之间的自然连接。A．select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.snoB．select student.* , sc.* from student , sc where student.sno=sc.snoC．select student.* , cno, grade from student , sc where student.sno=sc.snoD．select student.* , cno, grade from student join sc on student.sno=sc.sno