可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

View the Exhibit and&e


View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr;  Which statement describes the outcome of the command() 

  • AThe command executes successfully.
  • BThe command produces an error because the EMP table is owned by SCOTT.
  • CThe command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE withoutADMIN_OPTION.
  • DThe command produces an error because SL_REP does not have the SELECT privilege withGRANT_OPTION on the EMP table.
参考答案
参考解析:

环境测试一下: 1、创建一个用户,并解锁 sys@TEST0924> create user SL_REP identified by 123 account unlock; User created. 2、将connect、resource角色赋予 sys@TEST0924> grant connect,resource to SL_REP; Grant succeeded. 3、将grant any object privilege 赋予 sys@TEST0924> grant grant any object privilege to SL_REP; Grant succeeded. 4、SL_REP连接数据库,开始授予hr访问scott的emp表,赋予成功。所以选择A。 sys@TEST0924> conn SL_REP/123 Connected. sl_rep@TEST0924> grant select on scott.emp to hr; Grant succeeded. 

分类:1Z0-052题库
相关推荐

1、View the Exhibit and&e

View the Exhibit and examine the Flashback SCNs. A user has inserted wrong department data&ensp...

2、View the Exhibit and&e

View the Exhibit and examine the parameters.User A executes the following command to update the...

3、View the Exhibit and&e

View the Exhibit and examine the properties of the TT tablespace. Using Database Control, you&...

4、View the Exhibit and&e

View the Exhibit and examine the structure of the ORDERS table.Which task would require subquer...

5、View the Exhibit and&e

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the&...

6、View the Exhibit and&e

View the Exhibit and examine the structure of the EMP table.You executed the following command&...