首页 > 计算机类 > 等级考试 > 计算机二级 > VF > 学生表 (XS.DBF)的表结构为：学号 (XH，C，8)，姓名 (XM，C， 8)，性别 (XB，C，2)班级(BJ,C,6), 用Insert 命令向 XS表添加一条新记录，记录内容为：
XH XM XB BJ
99220101 王凌男 992201
下列命令中正确的是 ________。

学生表 (XS.DBF)的表结构为：学号 (XH，C，8)，姓名 (XM，C， 8)，性别 (XB，C，2)班级(BJ,C,6), 用Insert 命令向 XS表添加一条新记录，记录内容为：
XH XM XB BJ
99220101 王凌男 992201
下列命令中正确的是 ________。

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

查看答案

正确答案： A
答案分析：无

包含此试题的试卷：

计算机二级vf考试试题（三）

相关的试题

设有关系 Students (学号，姓名，年龄，性别，系别，家庭住址) ，其中，属性 “ 系名”是关系 DESP 的主键，用户要求访问 “家庭地址 ”的某个成分，如邮编、省、市、街道以及门牌号。关系 Students 的主键和外键分别是( )

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

设有关系 Students (学号，姓名，年龄，性别，系别，家庭住址) ，用户要求访问 “家庭地址 ”的某个成分，如邮编、省、市、街道以及门牌号，则 “家庭地址 ”是一个( )属性。

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

在标准 SQL中，建立数据库结构 ( 模式 ) 的命令为

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

检索所有比 "王华 "年龄大的学生姓名、年龄和性别。正确的SELECT 语句是

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

.在命令窗口中，显示当前数据库中所有40 岁(含 40 岁)以下、职称为 "教授 "、" 副教授 "的姓名和工资，应使用命令

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

下列命令中，修改库文件结构的命令是

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

ABC .DBF 是一个具有两个备注型字段的数据库文件，使用COPY TO PSQ 命令进行复制操作，其结果将

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

设数据库KSCJ.DBF有"姓名(C，6)"、"笔试(N，3)"、"上机(N，3)"等字段，执行下列命令：USE KSCJLIST记录号# 姓名笔试上机1 董一婉76 622 黄兴东65 533 姜浚75 844 赵飞45 95INDEX ON 上机+笔试TO SJGO TOP? RECNO( )显示的记录号是

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

假定有下述变量定义：姓名=[ 李华 ] ，性别 =[ 女] ，生日 ={70 /09/08) ，婚否 =.T .，要显示出以下格式的信息：李华，女，出生于70-09-08 .T.，可用命令

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

设有表示学生选课的三张表，学生 S(学号，姓名，性别，年龄，身份证号)，课程C(课号，课名)，选课 SC(学号，课号，成绩)，则表SC的关键字(键或码)为( )

A.INSERT INTO XS VALUES("99220101","王凌"," 男","992201") 　
B.INSERT TO XS VALUES("99220101"," 王凌"," 男","992201") 　　
C.INSERT INTO XS(XH,XM,XB,BJ) VALUES(99220101, 王凌, 男,992
D.INSERT TO XS(XH,XM,XB,BJ) VALUES("99220101"," 王凌"," 男","992

网站内容收集于网络，如有侵犯您的权益，请联系：gl@lm158.com，感谢您的支持
神奇助手题库网