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

The user Alice wants to grant all users query privileges on

题目
单选题
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 DBA issues this SQL command:CREATE USER scottIDENTIFIES by tiger;What privileges does the user Scott have at this point? ()

A. No privileges.

B. Only the SELECT privilege.

C. Only the CONNECT privilege.

D. All the privileges of a default user.


参考答案：A

第2题：

The DBA issues this SQL command:What privileges does the user Scott have at this point?()

A. No privileges.

B. Only the SELECT privilege.

C. Only the CONNECT privilege.

D. All the privileges of a default user.


参考答案：A

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


参考答案：D

第4题：

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

第5题：

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()

A.REVOKE ALL PRIVILEGES FROM USER tom

B.REVOKE ALL ON EMPLOYEE FROM USER tom

C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom

D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom


参考答案：B

第6题：

When should you create a role? ()

A. To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.

B. To grant a group of related privileges to a user.

C. When the number of people using the database is very high.

D. To simplify the process of granting and revoking privileges.

E. To simplify profile maintenance for a user who is constantly traveling.


参考答案：C, D

第7题：

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

第8题：

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

第9题：

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following  GRANT command：  GRANT ALL   ON orders， order_items   TO PUBLIC；   What correction needs to be done to the above statement？ （）

  • A、 PUBLIC should be replaced with specific usernames.
  • B、 ALL should be replaced with a list of specific privileges.
  • C、 WITH GRANT OPTION should be added to the statement.
  • D、 Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.

正确答案:D

第10题：

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

更多相关问题
相关内容