下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）A、GRANT INSERT ON emp TO acctsuperB、GRANT CREATE TABLE TO acctsuperC、GRANT SELECT ON emp TO acctsuperD、GRANT UPDATE ANY TABLE TO acctsuperE、GRANT CREATE SESSION TO acctsuper

第1题：

第2题：

第3题：

第4题：

第5题：

正确答案：D

第6题：

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

第7题：

授予sa用户在SCOTT.EMP表中SAL列的更新权限的语句是（）。

• A、GRANT CHANGE ON SCOTT.EMP TO SA
• B、GRANT UPDATE ON SCOTT.EMP（SAL） TO SA
• C、GRANT UPDATE （SAL） ON SCOTT.EMP TO SA
• D、GRANT MODIFY ON SCOTT.EMP（SAL） TO SA

第8题：

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***

第9题：

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;

第10题：

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

第11题：

第12题：

第13题：

第14题：

第15题：

第16题：

第17题：

第18题：

授予删除任何表的系统权限（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

第19题：

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.

第20题：

假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。

• A、GRANT CREATE ANY TABLE test
• B、GRANT CREATE ANY TABLE TO test
• C、TAKE CREATE ANY TABLE TO test
• D、ALTER CREATE ANY TABLE TO test

第21题：

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.

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

第23题：