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

What is true about the WITH GRANT OPTION clause?（）

题目
单选题
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.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which two statements are true about pool－based source NAT? ()(Choose two.)

A. PAT is not supported.

B. PAT is enabled by default.

C. It supports the address-persistent configuration option.

D. It supports the junos-global configuration option.


参考答案：B, C

第2题：

What is true about the grant?

A. It is for more than $1 million.

B. It is an extension of an existing grant.

C. It is awarded by the Bridgeport Revitalization Committee.

D. It is the largest the BRC has ever received.

答案：D
解析：

第3题：

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

第4题：

Which two statements about views are true? （）

  • A、A view can be created as read only.
  • B、A view can be created as a join on two or more tables.
  • C、A view cannot have an ORDER BY clause in the SELECT statement.
  • D、A view cannot be created with a GROUP BY clause in the SELECT statement.
  • E、A view must have aliases defined for the column names in the SELECT statement.

正确答案:A,B

第5题：

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

第6题：

（53）

A．RESTRICT

B．CASCADE

C．WITH GRANT OPTION

D．WITH CHECK OPTION


正确答案：B
解析：本题考查考生对权限管理相关SQL语句的掌握。
  收回权限的SQL语法：
  REVOKE 权限列表＞ON表名|视图名＞
  FROM用户列表＞RESTRICT|CASCADE
  其中：RESTRICT表示只收回指定用户的权限；CASCADE表示收回指定用户及其授予的其他用户的该权限。

第7题：

What is true about IP Source Guard with port security？（）

  • A、Binding should be manually configured.
  • B、It is not supported if IEEE 802.1x port-based authentication is enabled.
  • C、The DHCP server must support option 82， or the client is not assigned an IP address.
  • D、It filters based on source IP address only.

正确答案:C

第8题：

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.


参考答案：C

第9题：

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

第10题：

试述GRANT语句中WITH GRANT OPTION子句的作用。


正确答案:WITH GRANT OPTION子句说明被授权用户可以将指定的对象权限授予其他用户。该子句仅对对象权限有效，对语句权限无效。

更多相关问题
相关内容