赞题库-背景图

单项选择题

删除表Em_temp 的SQL语句是

A．DROP TABLE Em_temp
B．DELETE TABLE Em_temp
C．DROP FILE Em_temp
D．DELETE FILE Em_temp

<上一题目录下一题>

热门试题

单项选择题将表结构为（职工号，姓名，工资）的表Employee中工资最多的前3名记录存储到文本文件Em_text，正确的SQL命令是

A．SELECT * TOP 3 FROM Employee INTO FILE Em_text ORDER BY 工资
B．SELECT * TOP 3 FROM Employee TO FILE Em_text ORDER BY 工资
C．SELECT * TOP 3 FROM Employee INTO FILE Em_text ORDER BY 工资 DESC
D．SELECT * TOP 3 FROM Employee TO FILE Em_text ORDER BY 工资 DESC

单项选择题建立表Employee的视图Em_view，正确的SQL命令是

A．CREATE VIEW Em_view WHLIE SELECT 职工号,工资 FROM Employee
B．CREATE AS Em_view VIEW SELECT 职工号,工资 FROM Employee
C．CREATE VIEW Em_view AS SELECT 职工号,工资 FROM Employee
D．CREATE VIEW Em_view SELECT 职工号,工资 FROM Employee