第四章表数据操作20秋人大测试
第四章表数据操作1.[单选题]（ ）语句用于向表中添加数据。
A.insert
B.append
C.add_data
D.delete
正确答案:——A——
2.[单选题]下面关于 UPDATE 语句错误的是（ ）。
A.可以使用 DEFAULT 关键字将字段设置为默认值
B.可以使用 NULL 关键字将字段设置为空值
C.可使用 UPDATE 语句同时修改多行
D.如果 UPDATE 语句中没有指定搜索条件，则默认只能修改第一行
正确答案:——D——
3.[问答题]举例使用delete语句删除记录。<br>
正确答案:——use [学生管理]<br>go<br>delete from学生表<br>where学生编号='X007'<br>go<br>——
4.[单选题]关于delete语句，下面说法正确的是（ ）。
A.只能删除表中的一条记录
B.可以删除表中的多条记录
C.不可以删除表中的全部记录
D.可以删除表
正确答案:————
5.[单选题]在创建表时，（ ）是不能指定的。
A.表名
B.列名
C.列属性
D.表中的数据
正确答案:————
6.[单选题]在SQL语言中INSERT、DELETE、UPDATE实现的是（ ）。
A.查询功能
B.操作功能
C.定义功能
D.控制功能
正确答案:————
7.[问答题]按下表所示的内容用insert语句向“商品信息表”和“商品销售记录表”中插入记录。<br>表4“商品信息表”记录<br><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0style='border—collapse:collapse;border:none'><tr> <td width=103 valign=top style='width:77.4pt;border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 商品标识<br> </td> <td width=132 valign=top style='width:99.0pt;border:solid windowtext 1.0pt; border—left:none;padding:0cm 5.4pt 0cm 5.4pt'> 商品名称<br> </td> <td width=191 valign=top style='width:143.15pt;border:solid windowtext 1.0pt; border—left:none;padding:0cm 5.4pt 0cm 5.4pt'> 产地<br> </td> <td width=142 valign=top style='width:106.55pt;border:solid windowtext 1.0pt; border—left:none;padding:0cm 5.4pt 0cm 5.4pt'> 进货价<br> </td></tr><tr> <td width=103 valign=top style='width:77.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 101<br> </td> <td width=132 valign=top style='width:99.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 乒乓球拍<br> </td> <td width=191 valign=top style='width:143.15pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 广州<br> </td> <td width=142 valign=top style='width:106.55pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 120.00<br> </td></tr><tr> <td width=103 valign=top style='width:77.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 102<br> </td> <td width=132 valign=top style='width:99.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 羽毛球拍<br> </td> <td width=191 valign=top style='width:143.15pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 深圳<br> </td> <td width=142 valign=top style='width:106.55pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 360.00<br> </td></tr><tr> <td width=103 valign=top style='width:77.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 103<br> </td> <td width=132 valign=top style='width:99.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 网球拍<br> </td> <td width=191 valign=top style='width:143.15pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 江苏<br> </td> <td width=142 valign=top style='width:106.55pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 560.00<br> </td></tr> </table>表5“商品销售记录表”记录<br><table class=MsoNormalTable border=1 cellspacing=0 cellpadding=0style='border—collapse:collapse;border:none'><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 商品标识<br> </td> <td width=180 valign=top style='width:135.0pt;border:solid windowtext 1.0pt; border—left:none;padding:0cm 5.4pt 0cm 5.4pt'> 销售日期<br> </td> <td width=216 valign=top style='width:162.0pt;border:solid windowtext 1.0pt; border—left:none;padding:0cm 5.4pt 0cm 5.4pt'> 销售价格<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 101<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060601<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 150.00<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 101<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060602<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 140.00<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 102<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060601<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 410.00<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 102<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060602<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 400.00<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 102<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060603<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 390.00<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 103<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060601<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 600.00<br> </td></tr><tr> <td width=175 valign=top style='width:131.4pt;border:solid windowtext 1.0pt; border—top:none;padding:0cm 5.4pt 0cm 5.4pt'> 103<br> </td> <td width=180 valign=top style='width:135.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 20060602<br> </td> <td width=216 valign=top style='width:162.0pt;border—top:none;border—left: none;border—bottom:solid windowtext 1.0pt;border—right:solid windowtext 1.0pt; padding:0cm 5.4pt 0cm 5.4pt'> 620.00<br> </td></tr> </table> <br> <br>
正确答案:————
8.[问答题]写出T—SQL语句，对产品销售数据库（库名CPXS）产品表进行如下操作：<br> （1）插入如下记录<br> 0001空调3000200<br> 0203冰箱2500100<br> 0301彩电280050<br>（2）将产品数据库的产品表中的每种商品的价格打8折。<br> （3）将产品数据库的产品表中价格打8折后小于50的商品删除。<br>
正确答案:————
转载注明 ，无忧答案网
页:
[1]