单选题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.实现“取消用户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.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 appgrpB.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

3.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 DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC

4.删除用户账号命令是( )A.DROP USERB.DROP TABLE USERC.DELETE USERD.DELETE FROM USER

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

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    下列哪个语句将赋予用户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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第8题：

    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）

    • A、It fails with a "Resource Busy" error.
    • B、It deletes the rows successfully because the table is locked in SHARE mode.
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第9题：

    单选题
    下列哪个语句将赋予用户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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

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


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

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    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

  • 第20题：

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


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
    A

    It fails to delete the records because the records are locked in SHARE mode.

    B

    It deletes the rows successfully because the table is locked in SHARE mode

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    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
    解析： 暂无解析

相关内容