IBM(000-730)

单选题Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC REVOKE INSERT, DELETE FROM USER tom ON TABLE t

题目
单选题
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）
A

REVOKE ADD, DELETE FROM USER tom ON TABLE tab1

B

REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

C

REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

D

REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?()

A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom


参考答案：C

第2题：

Which of the following will DELETE all of the rows from table T03?()

A.DELETE * FROM TABLE T03

B.DELETE ALL FROM T03

C.DELETE * FROM T03

D.DELETE FROM T03


参考答案：D

第3题：

实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是( )。

A．REVOKE UPDATE (XH) ON TABLE FROM USER4;

B．REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;

C．REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;

D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;


正确答案：C
解析：在SQL中取消用户对数据的权限的命令是REVOKE UPDATE ()。本题中括号内的参数应该是XH，取消的用户是USER4，取消的操作权限是STUD，位置是在TABLE表上。所以全部正确的就是C选项。

第4题：

下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）

  • A、GRANT ADD ON TABLE tab1 TO John
  • B、GRANT INSERT ON tab1 TO John
  • C、GRANT ADD ON TABLE tab1 TO USER John
  • D、GRANT INSERT ON TABLE tab1 TO USER John

正确答案:D

第5题：

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()

A.REVOKE ALL PRIVILEGES FROM USER tom

B.REVOKE ALL ON EMPLOYEE FROM USER tom

C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom

D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom


参考答案：B

第6题：

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()

A.REVOKE DROP ON t1 FROM PUBLIC

B.REVOKE UPDATE ON t1 FROM PUBLIC

C.REVOKE DELETE ON t1 FROM PUBLIC

D.REVOKE CONTROL ON t1 FROM PUBLIC


参考答案：C

第7题：

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()

A.REVOKE ACCESS ON DATABASE FROM USER bob

B.REVOKE CONNECT ON DATABASE FROM USER tom

C.REVOKE tom FROM ACCESS ON DATABASE BY USER bob

D.REVOKE tom FROM CONNECT ON DATABASE BY USER bob


参考答案：B

第8题：

删除用户账号命令是( )

A.DROP USER

B.DROP TABLE USER

C.DELETE USER

D.DELETE FROM USER


正确答案：A 

第9题：

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?()

A.REVOKE ADD, DELETE FROM USER tom ON TABLE tab1

B.REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

C.REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

D.REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom


参考答案：D

第10题：

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

  • A、GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
  • B、GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
  • C、GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
  • D、GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

正确答案:C

更多相关问题
相关内容