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;

题目

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;

更多“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题

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 staffB、SELECT DISTINCT dept FROM staffC、SELECT (dept) UNIQUE FROM staffD、SELECT (dept) DISTINCT FROM staff

点击查看答案
第2题

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.

点击查看答案
第3题

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 managerB、GRANT select, insert, update ON student_grades TO ROLE managerC、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;

点击查看答案
第4题

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.

点击查看答案
第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_vuB、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_vuF、CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;

点击查看答案
第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 onlyB、Alice and ReenaC、Alice, Reena, and TimberD、Sue, Alice, Reena, and Timber

点击查看答案
第7题

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.

点击查看答案

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;

题目

更多“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题

第4题

第5题

第6题

第7题

相关内容