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

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

相似考题

1.（ 35 ） “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是A ） GRANT SELECT ， UPDATE （ grade ） ON TABLE sc TO user1B ） GRANT SELECT sc ， UPDATE sc . grade TO user1C ） GRANT SELECT ， UPDATE ON TABLE sc . grade TO user1D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1

2.The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()A. GRANT select ON dept TO ALL_ USER;B. GRANT select ON dept TO ALL;C. GRANT QUERY ON dept TO ALL_USERSD. GRANT select ON dept TO PUBLIC;

3.Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()A. MANAGER must be a role.B. It allows the MANAGER to pass the specified privileges on to other users.C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

4.User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT any transaction TO scott;C. GRANT EXECUTE ON dbms_flashback TO scott;D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

更多“单选题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 TA”相关问题

  • 第1题：

    “把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是（ ）。

    A．GRANT SELECT，UPDATE（grade）ON TABLE sc TO user1

    B．GRANT SELECT sc，UPDATE sc．grade TO user1

    C．GRANT SELECT，UPDATE ON TABLE sc．grade TO used

    D．GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc(grade) TO user1


    正确答案：A
    GRANT 允许对象的创建者给某用户或某组或所有用户（PUBLIC）某些特定的权限．对象创建后，除了创建者外，除非创建者赋予（GRANT）权限，其他人没有访问对象的权限． 一旦用户有某对象的权限，他就可以使用那个特权．不需要给创建者赋予（GRANT）对象的权限，创建者自动拥有对象的所有权限，包括删除它的权限

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

  • 第5题：

    授予删除任何表的系统权限（DROP ANY TABLE）给user1，并使其能继续授该权限给其他用户，以下正确的SQL语句是（）

    • A、Grant drop any table to user1
    • B、Grant drop any table to user1 with admin option
    • C、Grant drop table to user1
    • D、Grant drop any table to user1 with check potion

    正确答案: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题：

    You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）

    • A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
    • B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
    • C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
    • D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
    • E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

    正确答案:D

  • 第8题：

    User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *  ERROR at line 1：  ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）

    • A、Grant the RESOURCE role to SCOTT.
    • B、Add data files to the USERS tablespace.
    • C、Grant the CREATE ANY TABLE privilege to SCOTT.
    • D、Increase the space for SCOTT on the USERS tablespace.
    • E、Increase the size of the data file associated with the USERS tablespace

    正确答案:B,E

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

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

  • 第11题：

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

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

  • 第14题：

    “把查询sc表和更新sc表的grade列的权限授予用户user”的正确SQL语句是（ ）。

    A）GRANT SELECT sc，UP DATE sc．Grade TO user

    B）GRANT SELECT,UP DATE (grade) ON TABLE sc TO user

    C）GRANT SELECT,UP DATE ON TABLE sc．Grade TO user

    D）GRANT SELECT ON TABLE sc，UP DATE ON TABLE sc(grade) TO user


    正确答案：B

  • 第15题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）

    • A、ALTER DATABASE FLASHBACK ON;
    • B、GRANT SELECT any transaction TO scott;
    • C、GRANT EXECUTE ON dbms_flashback TO scott;
    • D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
    • E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
    • F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

    正确答案:B,C,D,F

  • 第16题：

    下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）

    • A、GRANT INSERT ON emp TO acctsuper
    • B、GRANT CREATE TABLE TO acctsuper
    • C、GRANT SELECT ON emp TO acctsuper
    • D、GRANT UPDATE ANY TABLE TO acctsuper
    • E、GRANT CREATE SESSION TO acctsuper

    正确答案:B,D,E

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

    The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?（）

    • A、GRANT select ON dept TO ALL_ USER;
    • B、GRANT select ON dept TO ALL;
    • C、GRANT QUERY ON dept TO ALL_USERS
    • D、GRANT select ON dept TO PUBLIC;

    正确答案:D

  • 第19题：

    You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）

    • A、GRANT select, insert, update ON student_grades TO manager
    • B、GRANT select, insert, update ON student_grades TO ROLE manager
    • C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
    • D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
    • E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;  
    • F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;

    正确答案:D

  • 第20题：

    User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

    • A、 ALTER DATABASE FLASHBACK ON
    • B、 GRANT SELECT any transaction TO scott
    • C、 GRANT EXECUTE ON dbms_flashback TO scott
    • D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
    • E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE
    • F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

    正确答案:B,C,D,F

  • 第21题：

    单选题
    You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? （）
    A

    CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    B

    CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

    C

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

    D

    CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

    E

    CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;


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

  • 第22题：

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

  • 第23题：

    多选题
    Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
    A

    MANAGER must be a role.

    B

    It allows the MANAGER to pass the specified privileges on to other users.

    C

    It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

    D

    It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

    E

    It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

    F

    It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.


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

相关内容