单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. E

题目
单选题
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
A

Alice only

B

Alice and Reena

C

Alice, Reena, and Timber

D

Sue, Alice, Reena, and Timber

相似考题

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.The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user

4.“把查询SC表和更新SC表的9rade列的权限授予用户user”的正确SQL语句是（ ）。A)GRANT.SELECT sc, UPDATE sc.grade TO userB)GRANT SELECT, UPDATE (grade) ON TABLE sc TO userC)GRANT SELECT, UPDATE ON TABLE sc.grade TO userD)GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grade) TO user

更多“The user Sue issues this SQL statement: GRANT SELECT ON sue.”相关问题

  • 第1题：

    The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

    A. Alice only

    B. Alice and Reena

    C. Alice, Reena, and Timber

    D. Sue, Alice, Reena, and Timber


    参考答案：C

  • 第2题：

    Scott issues the SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13)};GRANT SELECTON DEPTT0 SUE;If Sue needs to select from Scott‘s DEPT table, which command should she use?（）

    A.SELECT*FROMDEPT；

    B.SELECT*FROMSCOTT.DEPT；

    C.SELECT*FROMDBASCOTTDEPT；

    D.SELECT*FROMALL_USERSWHEREUSER_NAME=‘；SCOTT‘；ANDTABLENAME=‘；DEPT‘；；


    参考答案：B

  • 第3题：

    授予用户Jean可以查询帐户表的权限,使用的SQL语句是( )

    A GRANT SELECT ON 帐户 TO Jean

    B GRANT SELECT TO Jean ON 帐户

    C GRANT SELECT TO帐户 ON Jean

    D GRANT SELECT ON Jean TO 帐户


    参考答案A

  • 第4题：

    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

  • 第5题：

    The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）

    • A、no privileges
    • B、only the SELECT privilege
    • C、only the CONNECT privilege
    • D、all the privileges of a default user

    正确答案:A

  • 第6题：

    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

    • A、Alice only
    • B、Alice and Reena
    • C、Alice, Reena, and Timber
    • D、Sue, Alice, Reena, and Timber

    正确答案:C

  • 第7题：

    单选题
    Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）
    A

    SELECT*FROMDEPT；

    B

    SELECT*FROMSCOTT.DEPT；

    C

    SELECT*FROMDBASCOTTDEPT；

    D

    SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；


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

  • 第8题：

    单选题
    The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
    A

    Alice only

    B

    Alice and Reena

    C

    Alice, Reena, and Timber

    D

    Sue, Alice, Reena, and Timber


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

  • 第9题：

    单选题
    Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）
    A

    The commands execute successfully.

    B

    Command 6 produces an error because of circular role grant.

    C

    Command 5 produces an error because a role cannot be granted to another role.

    D

    Command 3 produces an error because the MGRROLE role already contains system privileges.

    E

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    F

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第10题：

    单选题
    The HR user creates a view with this command：  SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp；  Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user.  Which statement is true in this scenario？（）
    A

    HR can grant the privilege to JIM but without GRANT OPTION.

    B

    HR can grant the privilege to JIM because HR is the owner of the view.

    C

    SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.

    D

    HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.


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

  • 第11题：

    单选题
    The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）
    A

    No privileges.

    B

    Only the SELECT privilege.

    C

    Only the CONNECT privilege.

    D

    All the privileges of a default user.


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

  • 第12题：

    单选题
    A user named Arren is executing this query：   select table_name，operation，undo_sql  from  flashback_transaction_query t，  （select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123） e  where t.xid = e.xid；   When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem.  Which of the following SQL statements will correct this problem？（）
    A

     GRANT SELECT ANY TRANSACTION TO ARREN

    B

     GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN

    C

     GRANT SELECT_ANY_TRANSACTION TO ARREN

    D

     GRANT FLASHBACK TO ARREN

    E

     GRANT SELECT ANY VIEW TO ARREN


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

  • 第13题：

    The DBA issues this SQL command:What privileges does the user Scott have at this point?()

    A. No privileges.

    B. Only the SELECT privilege.

    C. Only the CONNECT privilege.

    D. All the privileges of a default user.


    参考答案：A

  • 第14题：

    “把查询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）对象的权限，创建者自动拥有对象的所有权限，包括删除它的权限

  • 第15题：

    The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following  GRANT command：  GRANT ALL   ON orders， order_items   TO PUBLIC；   What correction needs to be done to the above statement？ （）

    • A、 PUBLIC should be replaced with specific usernames.
    • B、 ALL should be replaced with a list of specific privileges.
    • C、 WITH GRANT OPTION should be added to the statement.
    • D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

    正确答案:D

  • 第16题：

    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

    • A、User process
    • B、Server process
    • C、System Monitor (SMON)
    • D、Process Monitor (PMON)
    • E、Checkpoint process (CKPT)

    正确答案:B

  • 第17题：

    The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）

    • A、No privileges.
    • B、Only the SELECT privilege.
    • C、Only the CONNECT privilege.
    • D、All the privileges of a default user.

    正确答案:A

  • 第18题：

    Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）

    • A、SELECT*FROMDEPT；
    • B、SELECT*FROMSCOTT.DEPT；
    • C、SELECT*FROMDBASCOTTDEPT；
    • D、SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；

    正确答案:B

  • 第19题：

    单选题
    The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）
    A

    no privileges

    B

    only the SELECT privilege

    C

    only the CONNECT privilege

    D

    all the privileges of a default user


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

  • 第20题：

    单选题
    The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following  GRANT command：  GRANT ALL   ON orders， order_items   TO PUBLIC；   What correction needs to be done to the above statement？ （）
    A

     PUBLIC should be replaced with specific usernames.

    B

     ALL should be replaced with a list of specific privileges.

    C

     WITH GRANT OPTION should be added to the statement.

    D

     Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.


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

  • 第21题：

    单选题
    A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）
    A

    Acquire locks on table queried 

    B

    Generate redo for statement 

    C

    Fetch data from disk into memory 

    D

    Write changes to disk


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

  • 第22题：

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

  • 第23题：

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


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

  • 第24题：

    单选题
    Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）
    A

    SELECT*FROMDEPT；

    B

    SELECT*FROMSCOTT.DEPT；

    C

    SELECT*FROMDBASCOTTDEPT；

    D

    SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；


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

相关内容