题目内容（请给出正确答案）

[单选题]

To erase a column in a table, we use the command in SQL:

A.Delete

B.Alter

C.Erase

D.Update

提问人：网友tanliquan 发布时间：2022-01-07

参考答案

查看官方参考答案

如搜索结果不匹配，请联系老师获取答案

网友答案

查看全部（）

· 有4位网友选择 B，占比44.44%
· 有2位网友选择 D，占比22.22%
· 有2位网友选择 C，占比22.22%
· 有1位网友选择 A，占比11.11%

ABCD

提交我的答案

登录提交答案，可赢取奖励机会。

登录/注册

您可能会需要：

重置密码查看订单联系客服

安装简答题APP，拍照搜题省时又省心！

更多“To erase a column in a table, …”相关的问题

第1题

建立如下数据库表： Create table depa ( Depid int primary key, Depname nvarchar(20) not null ) Create table employee ( Employeeid int not null, Depid int not null, Name nvarchar(20) not null ) 要想保证employee表中的每一个雇员是唯一的，且只能属于在depa表中已存在的部门，最佳的做法是（）

A、Employeeid和depid设为组合主键

B、Employeeid设为主键，同时在depid列上创建一个外键约束

C、Employeeid设为主键，同时在depid列上创建一个检查约束

D、在Employeeid列上创建一个唯一约束，同时在depid列上创建一个外键约束

点击查看答案

第2题

The SQL command to modify record(s) in a tabled is :

A、ALTER

B、INSERT

C、UPDATE

D、DELETE

点击查看答案

第3题

What is the output of the following code? int X, Y; for(X=1;X<=2;x++) for(y="3;Y<=4;Y++)" printf("%d\n",x*y);> A、3 4 6 8

B、4 5 5 6

C、1 3 2 4

D、3 4 6 8

点击查看答案

第4题

To give database user ‘Zhang’ the privilege of modifying balance on table account, Which of the following statements is RIGHT:

A、GRANT UPDATE(balance) ON account TO Zhang ;

B、GRANT UPDATE balance OF account TO Zhang ;

C、REVOKE UPDATE(balance) ON account TO Zhang ;

D、REVOKE UPDATE balance OF account FROM Zhang ;

点击查看答案

第5题

Values of attribute Customer_ID in table BORROW(Customer_ID, Loan_no) must be the values of Customer_ID that have already existed in table CUSTOMER(Customer_ID, Customer_Name, Address), this constraint is called :

A、Entity integrity

B、Referential integrity

C、Check constraint

D、User defined constraint

点击查看答案

第6题

To give the privileges of access database object to users, which command of the following should be used :

A、GRANT

B、REVOKE

C、CREATE

D、GIVE

点击查看答案

第7题

SQL statement using Comparison predicate >=ALL can be rewrite by using the Aggregate Function of :

A、MAX( )

B、MIN( )

C、AVG( )

D、COUNT( )

点击查看答案

第8题

SQL statement using Comparison predicate <=all can be rewrite by using the aggregate function of> A、MAX( )

B、MIN( )

C、AVG( )

D、COUNT( )

点击查看答案

第9题

Tables in SQL query statements can be renamed to distinguish its different usages. Rename a table is used in which clause :

A、SELECT

B、FROM

C、WHERE

D、GROUP BY

点击查看答案

第10题

In log-based recovery mechanism, some transactions need to be undone, while others need to be redone to recover after a failure. <t0 start> <t0, 90 a, 100,> <t0, commit> <t1 start> <t1, 100 b, 90,> What recovery actions do we need to perform according to the given log?

A、undo(T0) & undo (T1)

B、undo(T0) & redo (T1)

C、redo(T0) & undo (T1)

D、redo(T0) & redo (T1)

点击查看答案