![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
[主观题]
对于已经创建好的学生信息表,可以使用SQL语句“ALTERTABLE学生信息()年龄”删除年龄列。
A.DROPCOLUMN
B.DROP
C.DELETE
D.ALTERCOLUMN
查看答案
![](https://static.youtibao.com/asksite/comm/h5/images/solist_ts.png)
A.DROPCOLUMN
B.DROP
C.DELETE
D.ALTERCOLUMN
A. ALTER COLUMN
B. DELETE
C. DROP
D. DROP COLUMN
A. DELETE Age from S
B. ALTER TABLE S DROP Age
C. UPDATE S Age
D. ALTER TABLE S ‘Age’
A.DELETE FOR AGE>30 B.DELETE FROM S WHERE AGE>30
C.DELETE S FOR AGE>30 D.DELETE S WHERE AGE>30
A.交合选择
B.投影和选择
C.选择和连接
D.连接和投影
A.SELECT TOP 5 姓名, 年龄 FROM 学生表
B.SELECT TOP 5 姓名, 年龄 FROM 学生表 ORDER BY 年龄
C.SELECT TOP 5 姓名, 年龄 FROM 学生表 ORDER BY 年龄 DESC
D.SELECT TOP 5 WITH TIES姓名, 年龄 FROM 学生表
A.ALTER TABLE S DROP COLUMN 年龄 B.DELETE 年龄 FROM S
C.ALTER TABLE S DELETE COLUMN 年龄 D.ALTEER TABLE S DELETE 年龄
A) 从S表中彻底删除年龄大于60岁的记录
B) S表中年龄大于60岁的记录被加上删除标记
C) 删除S表
D) 删除S表的年龄列