【简答题】【消耗次数：1】
SQL中修改表结构用[填空]命令。
参考答案：
复制
纠错
相关题目
【单选题】
修改学生表的结构时要删除“家庭地址”属性用的命令是（ ）。
①
A．UPDATE TABLE 学生 DELETE COLUMN ‘家庭地址’
②
B．UPDATE TABLE 学生 DROP COLUMN ‘家庭地址’
③
C．ALTER TABLE 学生 DELETE COLUMN ‘家庭地址’
④
D．ALTER TABLE 学生 DROP COLUMN ‘家庭地址’
【简答题】
SQL中，表有三种： [填空]、临时表(虚表)和基本表。
【简答题】
在LINQ to SQL中，将SQL Server数据库映射为[填空1]类，表映射为[填空2]，存储过程映射为[填空3] 。
【简答题】
将学生表STUDENT中的学生年龄(字段名就是AGE)增加1岁,应该使用的SQL命令就是UPDATE STUDENT[填空1]
【简答题】
在SQL中使用[填空1]语句修改基本关系的定义。
【单选题】
在表结构为（职工号，工资）的表Employee中查询职工号的第5位开始的4 个字符为“0426”职工情况，正确的 SQL 命令是
①
SELECT * FROM Employee WHERE STR(职工号,5,4)=0426
②
SELECT * FROM Employee WHERE SUBSTR(职工号,5,4）=0426
③
SELECT * FROM Employee WHERE STR(职工号,4,5)=0426
④
SELECT * FROM Employee WHERE SUBSTR(职工号,4,5）=0426
随机题目
【单选题】
If a book is in English, [] means a slow progress for you.
①
as
②
which
③
what
④
that
【单选题】
As I turned around, I heard a loud noise [] for the bookshelf had collapsed.
①
comma
②
semicolon
【单选题】
The computer could calculate much faster and better than man [] however, it could not drink.
①
comma
②
semicolon
【判断题】
The semicolon is used between two coordinate clauses which are not linked by a conjunction.
①
正确
②
错误
【单选题】
He wrote a lot of novels, and many of [] were translated into English.
①
it
②
them
③
which
④
that
【单选题】
It is his doy, according to Li Lei, [] saved him from the trap.
①
who
②
which
③
that
④
what
【单选题】
Kunming is my favorite city [] in fact, I plan to spend a month there this summer.
①
comma
②
semicolon