多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create

题目
多选题
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.

相似考题

1.You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

2.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 onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber

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.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;

更多“多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create ”相关问题

  • 第1题：

    Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?()

    A. System privileges apply only to the PDB in which they are used.

    B. Local users cannot use local system privileges on the schema of a common user.

    C. The granter of system privileges must possess the set container privilege.

    D. Common users connected to a PDB can exercise privileges across other PDBs.

    E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.


    参考答案：A, C, E

  • 第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_USERS
    • D、GRANT select ON dept TO PUBLIC;

    正确答案:D

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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.

    正确答案:B

  • 第6题：

    Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）

    • A、System privileges apply only to the PDB in which they are used.
    • B、Local users cannot use local system privileges on the schema of a common user.
    • C、The granter of system privileges must possess the set container privilege.
    • D、Common users connected to a PDB can exercise privileges across other PDBs.
    • E、System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

    正确答案:A,C,E

  • 第7题：

    You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）

    • A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
    • B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
    • C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

    正确答案:A

  • 第8题：

    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

  • 第9题：

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

  • 第10题：

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


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

  • 第11题：

    多选题
    Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）
    A

    System privileges apply only to the PDB in which they are used.

    B

    Local users cannot use local system privileges on the schema of a common user.

    C

    The granter of system privileges must possess the set container privilege.

    D

    Common users connected to a PDB can exercise privileges across other PDBs.

    E

    System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.


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

  • 第12题：

    单选题
    What is true about the WITH GRANT OPTION clause?（）
    A

    It allows a grantee DBA privileges.

    B

    It is required syntax for object privileges.

    C

    It allows privileges on specified columns of tables.

    D

    It is used to grant an object privilege on a foreign key column.

    E

    It allows the grantee to grant object privileges to other users and roles.


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

  • 第13题：

    下面哪些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

  • 第14题：

    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

  • 第15题：

    You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）

    • A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
    • B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
    • C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

    正确答案:A

  • 第16题：

    You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：  SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）；  This command errorsout displaying the following message：  ERROR at line 1：  ORA-01031： insufficient privileges  ORA-06512： at "SYS.DBMS_RMIN"， line 115  ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1  What action would you take to overcome this error？（）

    • A、 grant SYSDBA to the user
    • B、 grant SYSOPER to the user
    • C、 grant the RESOURCE role to the user
    • D、 use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
    • E、 grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package

    正确答案:E

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    What is true about the WITH GRANT OPTION clause?（）

    • A、It allows a grantee DBA privileges.
    • B、It is required syntax for object privileges.
    • C、It allows privileges on specified columns of tables.
    • D、It is used to grant an object privilege on a foreign key column.
    • E、It allows the grantee to grant object privileges to other users and roles.

    正确答案:E

  • 第20题：

    单选题
    You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）
    A

    CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

    B

    CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

    C

    GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***


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

  • 第21题：

    单选题
    View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION；  Which statement is true about the user SKD afterhe/she is granted this role（）
    A

    The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.

    B

    The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.

    C

    The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.

    D

    The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them


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

  • 第22题：

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

  • 第23题：

    单选题
    You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）
    A

    CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;

    B

    CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;

    C

    GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***


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

  • 第24题：

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


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

相关内容