当前位置: Oracle DBA培训网-优技培训 >> 071题库 >

【071题库】最新OCP-071考试题库解析-第24题

【071题库】最新OCP-071考试题库解析-第24题

071考试是OCP考试科目的一种,由于071考题多变,我们专门收集整理了最新的考试题库,并对这些考题进行讲解,希望可以帮助广大考生。

每周五晚8点,我们有免费的OCP解析公开课,地址:https://ke.qq.com/course/326223  OCP题库交流群:1015267481,验证ocp

-------------------------------------------------------

071题库-第24题、choose the best answer:

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:

GRANT ALL

ON orders, order_items

TO PUBLIC;

What must be done to fix the statement?

A) ALL should be replaced with a list of specific privileges.

B) WITH GRANT OPTION should be added to the statement.

C) PUBLIC should be replaced with specific usernames.

D) Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.

Answer:D

(SQL> grant all on sales,products to public;

grant all on sales,products to public

*

第 1 行出现错误:

ORA-00905: 缺失关键字

)

提问改动了,这道题出现很多次,注意语法。

技术沙龙MORE+

标签错误:<!-- #Label# labelId=20160707140604 moduleId=1 classId=12231768634 orderby=2 fields=url,title,u_info attribute= datatypeId=22192428132 recordCount=3 pageSize= <htmlTemplate><dt><img src="/images/index_26${index}.jpg" width="100" height="62" /><a href="$url" title="${title}">${title}</a><span>${api.left(u_info,60)}</span></dt></htmlTemplate> -->
我要参加技术沙龙