ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-165

047-165

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 10:37:53 0 删除 编辑
165. View the Exhibit and examine the structure of the ORDERS table.
The ORDERS table belongs to the user OE. HR is another user in the database.
Evaluate the commands issued by users OE and HR in the following order:
Statement 1 by user OE: GRANT SELECT,UPDATE(customer_id, order_total) ON
orders TO hr;
Statement 1 by user HR: SELECT * FROM oe.orders;
Statement 2 by user HR: UPDATE oe.orders SET order_total= 10000;
Which statement is true regarding the above commands?
A. Statement 1 by user OE would not work because the statement has to be issued
by the DBA.
B. Statement 2 by user HR would not work because the grant is only for SELECT
in a subquery of update.
C. There are no errors in the statements issued by OE and HR; all the statements
would execute successfully.
D. Statement 1 by user HR would not work because SELECT and UPDATE privileges
have been granted only on CUSTOMER_ID and ORDER_TOTAL columns.
Answer: C

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718969/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-151
下一篇: 047-166
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204122