select*from student where type=”数学”and type=”语文”
select*from student where type=”数学”or type=”语文”
select*from student where type in(”数学”,”语文”)
select*from student where type in(”数学”、”语文”)
第1题:
有如下的记录类型
Type student
id As String
name As String
age As Integer
End Type
则正确引用该记录类型变量的代码是( )
A.student.name=”Sias”
B.Dim s As student
s.mane=”Sias”
C.Dim s As type student
s.name=”Sias”
D.Dim s As type
s.name=”Sias”
第2题:
要在 “ 成绩 ” 表中插入一条记录 , 应该使用的 SQL 语句是:【 14 】 成绩 ( 学号 , 英语 , 数学 , 语文 ) V A L UES ( " 2001100111 " ,9l,78,86)
第3题:
( 35 )如下程序段定义了学生成绩的记录类型,由学号、姓名和三门课程成绩(百分制)组成。
Type Stud
no As Integer
name As String
score ( 1 to 3 ) As Single
End Type
若对某个学生的各个数据项进行赋值,下列程序段中正确的是
A ) Dim S As Stud
Stud.no = 1001
Stud.name = ” 舒宜,,
Stud.score = 78,88,96
B ) Dim S As Stud
S.no = 1001
S.name 二 ” 舒宜,,
S.score 二 78,88,96 \
C ) Dim S As Stud
Stud.no = 1001
Stud.name = ” 舒宜,,
Stud.score ( 1 )= 78
Stud.score ( 2 )= 88
Stud.score ( 3 )= 96
D ) Dim S As Stud
S.no = 1001
S.name = ” 舒宜,,
S.score ( 1 )= 78
S.score ( 2 )= 88
S.score ( 3 )= 96
第4题:
要建立一个随机文件记录学生的信息,如下定义了学生的记录类型,由学号、姓名、5门课程成绩(百分制)组成,下列的定义正确的是( )。
A.Type sru no As Integer name As String score(1 To 5)As Single End Type
B.Type stu no As Integer name As String*10 score()As Single End Type
C.Type stu no As Integer name As String*10 score(1 To 5)As Single End Type
D.Type stu no As Integer name As String score()As Single End Type
第5题:
(12)要建立一个随机文件记录学生的信息,下列定义了学生的记录类型,由学号、姓名、五门课程成绩(百分制)组成,下列的定义正确的是。A.Type stu no As Integer name As String score(1 To 5)As Single End Type B.Type stuno As Integename As String*10score()As SingleEnd TypeC.Type stu no As Integer name As String*10 score(1 To 5)As Single End Type D.Type stuno As Integername As Stringscore()As SingleEnd Type
第6题:
如下程序段定义了学生成绩的记录类型,由学号、姓名、三门课程成绩(百分制)组成。 Type Stud no As Integer name As String*10 score(1 To 3) As Single End Type 若对某个学生的各数据项进行赋值,下列程序段正确的是( )。
A.Dim S As Stud Stud.no=0201 Stud.name="李平" Stud.score=78,88,96
B.Dim S As Stud S.no=0201 S.name="李平" S.score=78,88,96
C.Dim S As Stud S.no=0201 S.name="李平" S.score(1)=78 S.score(2)=88 S.score(3)=96
D.Dim S As Stud Stud.no=0201 Stud.name="李平" Stud.score(1)=78 Stud.score(2)=88 Stud.score(3)=96
第7题:
设有如下的用户定义类型: Type Student number As String name As string age As Integer End Type 则以下正确引用该类型成员的代码是______。
A. Student name="李明”
B.Dim s As Student s.name="李明"
C.Dim s As Type Student s.name="李明"
D.Dim s As Type s.name="李明"
第8题:
假设有如下的记录类型: Type Student number As String name AS String age As Integer End Type 则正确引用该记录类型变量的代码是______。
A.Student. name="" s. name="张红"
B.Dim s As Student s. Dame="张红"
C.Dim s As Type Student s. name="张红"
D.Dim s As Type s. name="张红"
第9题:
设有如下的记录类型: TypeStudent number As String name AS String age As Integer End Type 则正确引用该记录类型变量的代码是( )。
A.Student.name="张红"
B.Dim s As Student s.name="张红"
C.Dim s As Type Student s.name="张红"
D.Dim s As Type s.name="张红"
第10题:
下列数据类型定义中,正确的是
A.Type Student Num As Long Name As String End Type
B.Type Student Num As Integer Name As String * 10 End Type
C.Private Type Num As Long Score As Single End Type
D.Private Type Student Name As String Score(10)As String * 10 End Type