单选题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 PUBLIC

B

REVOKE UPDATE ON t1 FROM PUBLIC

C

REVOKE DELETE ON t1 FROM PUBLIC

D

REVOKE CONTROL ON t1 FROM PUBLIC

相似考题

1.实现“取消用户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;

2.实现“收回用户U4对学生表(STUD)中学号(XH)的修改权”这一功能的正确SQL语句是______。A．REVOKE UPDATE(XH) ON TABLE FROM U4B．REVOKE UPDATE(XH) ON TABLE STUD FROM PUBLICC．REVOKE UPDATE (XH) ON TABLE STUD FROM U4D．REVOKE ALL PRIVILEGES ON TABLE STUD FROM U4

3.实现“收回用户U4对学生表STUD中学号(XH)的修改权”这一功能的正确SQL语句是 ______。A．REVOKE UPDAE(XH)ON TABLE FROM U4B．REVOKE UPDAE(XH)ON TABLE STUD FROM PUBLICC．REVOKE UPDAE(XH)ON TABLE STUD FROM U4D．REVOKE ALL PRIVILEGES ON TABLE FROM U4

4.下列SQL语句中,能够实现“收回用户U4对学生表(STUD)中学号(XH)的修改权”这一功能的是()。A. REVOKE UPDATE(XH) ON TABLE FROM U4B. REVOKE UPDATE(XH) ON TABLE FROM PUBLICC. REVOKE UPDATE(XH) ON STUD FROM U4D. REVOKE UPDATE(XH) ON STUD FROM PUBLIC

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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题：

    A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

    A.REFERENCES

    B.SELECT

    C.UPDATE

    D.ALTER


    参考答案：D

  • 第2题：

    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

  • 第3题：

    实现“收回用户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；


    正确答案：C

  • 第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

    答案：C
    解析：
    本题考查数据库安全中的授权知识。标准SQL中的权限收回语法为：REVOKE<权限>[，<权限>…]ON[<对象类型>]<对象名>FROM<用户>[，<用户>...]；其中属性列的修改权限用UPDATE（<列名>）来表达；PUBLIC表示所有用户。

  • 第5题：

    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 T2
    • B、SELECT * FROM T1 EXCEPT SELECT * FROM T2
    • C、SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
    • D、SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

    正确答案:B

  • 第6题：

    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

  • 第7题：

    A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

    • A、REFERENCES
    • B、SELECT
    • C、UPDATE
    • D、ALTER

    正确答案:D

  • 第8题：

    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

  • 第9题：

    The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

    • A、The command fails because SCOTT still has privileges.
    • B、The command succeeds and privileges are revoked from JIM.
    • C、The command fails because HR cannot revoke the privileges from JIM.
    • D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

    正确答案:C

  • 第10题：

    单选题
    The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
    A

    The command fails because SCOTT still has privileges.

    B

    The command succeeds and privileges are revoked from JIM.

    C

    The command fails because HR cannot revoke the privileges from JIM.

    D

    The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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 T2

    B

    SELECT * FROM T1 EXCEPT SELECT * FROM T2

    C

    SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1

    D

    SELECT * FROM T1 NOT EXISTS SELECT * FROM T2


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）
    A

    SELECT * FROM t1 UNION SELECT * FROM t2

    B

    SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

    C

    SELECT * FROM t1 INTERSECT SELECT * FROM t2

    D

    SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    假设需要回收为用户test授予的CREATE ANY TABLE系统权限,可以使用如下()语句。

    A.TAKE BACK CREATE ANY TABLE FROM test

    B.REVOKE CREATE ANY TABLE FROM test

    C.REVOKE CREATE ANY TABLE test

    D.TAKE BACK CREATE ANY TABLE test


    参考答案：B

  • 第16题：

    下列SQL语句中，能够实现“收回用户ZHAO对学生表（STUD）中学号（XH） 的修改权”这一功能的是（）

    • A、REVOKE UPDATE(XH) ON TABLE FROM ZHAO       
    • B、REVOKE UPDATE(XH) ON TABLE FROM PUBLIC
    • C、REVOKE UPDATE(XH) ON STUD FROM ZHAO         
    • D、REVOKE UPDATE(XH) ON STUD FROM PUBLIC

    正确答案:C

  • 第17题：

    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

  • 第18题：

    Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）

    • A、REVOKE SELECT FROM user2 ON TABLE org.tab1
    • B、REVOKE SELECT ON TABLE org.tab1 FROM user2
    • C、REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
    • D、REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

    正确答案:B

  • 第19题：

    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

  • 第20题：

    假设需要回收为用户test授予的CREATE ANY TABLE系统权限，可以使用如下（）语句。

    • A、TAKE BACK CREATE ANY TABLE FROM test
    • B、REVOKE CREATE ANY TABLE FROM test
    • C、REVOKE CREATE ANY TABLE test
    • D、TAKE BACK CREATE ANY TABLE test

    正确答案:B

  • 第21题：

    单选题
    Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）
    A

    SELECT * FROM t1 UNION SELECT * FROM t2

    B

    SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

    C

    SELECT * FROM t1 INTERSECT SELECT * FROM t2

    D

    SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
    A

    REFERENCES

    B

    SELECT

    C

    UPDATE

    D

    ALTER


    正确答案： B
    解析： 暂无解析

相关内容