单选题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 PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DEL

题目

单选题

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?（）

REVOKE DROP ON t1 FROM PUBLIC

REVOKE UPDATE ON t1 FROM PUBLIC

REVOKE DELETE ON t1 FROM PUBLIC

REVOKE CONTROL ON t1 FROM PUBLIC

更多“单选题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 PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DEL”相关问题

第1题

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()A.REVOKE ALL PRIVILEGES FROM USER tomB.REVOKE ALL ON EMPLOYEE FROM USER tomC.REVOKE EXECUTE ON EMPLOYEE FROM USER tomD.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

点击查看答案
第2题

实现“收回用户U4对学生表STUD中学号(XH)的修改权”这一功能的正确SQL语句是______。A．REVOKE UPDATE(XH)ON TABLE FROM U4；B．REVOKE UPDATE(XH)ON TABLE STUD FROM PUBLIC；C．REVOKE UPDATE(XH)ON TABLE STUD FROM U4；D．REVOKE ALL PRIVIL EGES ON TABLE FROM U4；

点击查看答案
第3题

假设需要回收为用户test授予的CREATE ANY TABLE系统权限,可以使用如下()语句。A.TAKE BACK CREATE ANY TABLE FROM testB.REVOKE CREATE ANY TABLE FROM testC.REVOKE CREATE ANY TABLE testD.TAKE BACK CREATE ANY TABLE test

点击查看答案
第4题

下列SQL语句中，能够实现“收回用户ZHAO对学生表（STUD）中学号（XH）的修改权”这一功能的是（）。A.REVOKE UPDATE（XH）ON STUD TO ZHAO B.REVOKE UPDATE（XH）ON STUD TO PUBLIC C.REVOKE UPDATE（XH）ON STUD FROM ZHAO D.REVOKE UPDATE（XH）ON STUD FROM PUBLIC

点击查看答案
第5题

下列SQL语句中，能够实现“收回用户ZHAO对学生表（STUD）中学号（XH）的修改权”这一功能的是（）A、REVOKE UPDATE(XH) ON TABLE FROM ZHAO B、REVOKE UPDATE(XH) ON TABLE FROM PUBLICC、REVOKE UPDATE(XH) ON STUD FROM ZHAO D、REVOKE UPDATE(XH) ON STUD FROM PUBLIC

点击查看答案
第6题

Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）A、SELECT * FROM T1 MINUS SELECT * FROM T2B、SELECT * FROM T1 EXCEPT SELECT * FROM T2C、SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D、SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

点击查看答案
第7题

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 tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

点击查看答案

单选题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 PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DEL

题目

更多“单选题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 PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DEL”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容