违法和不良信息举报 联系客服
免费注册 登录

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;
参考答案和解析
正确答案:D
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第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题：

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

第3题：

（ 35 ） “ 把查询 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 user1

D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1


正确答案：A

第4题：

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

第5题：

要将部门表Dept中name列的修改权限赋予用户ming，并允许ming将该权限授予他人，实现该要求的SQL语句如下：GRANT UPADTE（name） ON TABLE DEPT TO MING （ ）

A.FOR ALL
B.CASCADE
C.WITH GRANT OPTION
D.WITH CHECK OPTION

答案：C
解析：
授权命令GRANT语法格式GRANT<权限>ON表【（列名）】 TO 用户【WITH GRANT OPTION】WITH GRANT OPTION这个选项表示该用户可以将自己拥有的权限授权给别人

第6题：

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

第7题：

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


参考答案：B

第8题：

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

第9题：

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

正确答案:B

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

正确答案:D

更多相关问题
相关内容