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

第1题：

第2题：

第3题：

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;

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

第5题：

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?（）

• A、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
• B、CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
• C、CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
• D、CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
• E、CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
• F、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

第6题：

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.

第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'；；

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）

• A、SELECT UNIQUE dept FROM staff
• B、SELECT DISTINCT dept FROM staff
• C、SELECT (dept) UNIQUE FROM staff
• D、SELECT (dept) DISTINCT FROM staff

第15题：

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.

第16题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command on the EMP_DEPT_VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第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

第18题：

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;

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

第20题：

第21题：

第22题：

第23题：

第24题：