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

[主观题]

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 ;

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

参考答案

查看官方参考答案

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

您可能会需要：

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

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

更多“To give database user ‘Zhang’ …”相关的问题

第1题

Please briefly share how you manage your closet or refrigerators via using relevant logistic management theory,and explain why.

点击查看答案

第2题

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

点击查看答案

第3题

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

点击查看答案

第4题

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

A、MAX( )

B、MIN( )

C、AVG( )

D、COUNT( )

点击查看答案

第5题

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

B、MIN( )

C、AVG( )

D、COUNT( )

点击查看答案

第6题

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

点击查看答案

第7题

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)

点击查看答案

第8题

"When a transaction is failed in the middle of its execution, the modification that has been made to the database by this transaction before failure time must be aborted to guarantee the consistency of database", indicates which property of transaction:

A、Atomicity

B、Consistency

C、Isolation

D、Durability

点击查看答案

第9题

LOG file must be used in the recovery of database. To re-execute the transaction that has been committed before failure time, which command should be used on the LOG records ?

A、Undo

B、Redo

C、COMMIT

D、ROLLBACK

点击查看答案