更多"以下是学生(STUDENT)表所包含的全部列的定义: ID "的相关试题:
[单项选择]以下是学生(STUDENT)表所包含的全部列的定义:
ID NUMBER(9) PK
LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
ENROLL_DATE DATE
请看如下的SQL脚本(语句),应该怎样修改才可以使它运行
A. /修改ACCEPT命令
B. 在SELECT子句中添加一列
C. 在ACCEPT命令中定义一个数据类型
D. 将单引号改成双引号
[单项选择]学生(STUDENT)表包括了如下的列定义:
ID NUMBER(9) PK
LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
SUBJECT_ID NUMBER(9)
比较以下的两个SQL语句,其结果将有哪些不同
(1)SELECT DISTINCT subject_id, last_name, first_name
FROM student
ORDER BY 1;
(2)SELECT id, last_name, first_name, subject_id
FROM student
ORDER BY subject_id;
A. 第一个语句的结果将以字母顺序排序,而第二个语句则不是
B. 第一个语句将限制重复的subject_id,而第二个语句则不是
C. 第二个语句将从输出结果中去掉重复行,而第一个语句则不能
D. 第一和第二个语句将显示学生(STUDENT)表中一些值的不同组合
[填空题]设有如下记录类型:
Type student
Number As String*10
Name As String*8
End Type
窗体中有若干控件,单击其中的一个按钮Command1时,执行如下事件过程,该过程的功能是把数据输出到指定的文件中。根据题意,请完善下列程序。
Private Sub Command1_click( )
Dim stu As student
Open"C:/file. dat" For Random As #1 Len=Len( 【13】 )
Title $="写记录到随机文件"
Str1 $="请输入学生名"
Str2 $="请输入学生名"
For i=1 To 5
stu. Number=InputBox(Str1 $, Title $)
stu. Name=InputBox$(Str2 $, Title $)
【14】 #1, i, stu
Next i
Close 【15】
End Sub
[填空题]设有如下记录类型:
Type student
Number As String*10
Name As String*8
End Type
窗体中有若干控件,单击其中的一个按钮Command1时,执行如下事件过程,该过程的功能是把数据输出到指定的文件中。根据题意,请完善下列程序。
Private Sub Command1_click( )
Dim stu As student
Open"C:/file. dat" For Random As #1 Len=Len( 【13】 )
Title $="写记录到随机文件"
Str1 $="请输入学生名"
Str2 $="请输入学生名"
For i=1 To 5
stu. Number=InputBox(Str1 $, Title $)
stu. Name=InputBox$(Str2 $, Title $)
【14】 #1, i, stu
Next i
Close 【15】
End Sub
[单项选择]设有如下的记录类型:
Type Student
Number As String
Name As String
Age As Integer
End Sub
则能正确引用该记录类型变量的代码是( )。
A. Student.name=""
B. Dim s As Students.name=“张红”
C. Dims As Tye Students.name=“张红”
D. DimsAsTypes.name=“张红”
[单项选择]
Normally a student should attend a certain number of classes to graduate, and each lesson which he attends offers him a credit (学分) which he may count towards a degree. In a lot of American universities the total work for a degree consists of six courses each lasting for one term. A typical course consists of four classes per week; normally a student would expect to take four years attending two terms each year. It is possible to spread the period of work for the degree over a longer period. It is also possible for a student to move between one university and another during his degree course, though this is not in fact done as a regular practice.
For each course that follows a student is given a grade, which is recorded, and the record is available for the student to show to prospective employers. All this imposes a sustainable pressure and strain of work, but despite of this, a few students still find time for great activity in student affairs. Elections to positions in
A. 6
B. 4
C. 24
D. 10
[填空题]Normally a student must attend a certain number of courses
in order to graduate, and each course which he attends and gives him a 41 ______
credit which he may count towards a degree. In many American universities
the total work for a degree consists of thirty-six courses each lasts for 42 ______
one semester. A typical course consists of three classes per week for fifteen
weeks; while attend a university, a student will probably attend four or 43 ______
five courses during each semester. Normally a student would expect to
take four years attending two semesters each year. It is possible to spread
the period of work for the degree over a long period. It is also possible 44 ______
for a student to move between one university and another during his degree
course, though this is not in fact done for a regular practice. 45 ______
For every course that he follows a stud