159.View the Exhibit and examine the user information.

来源：互联网发布：win10 pe 知乎编辑：程序博客网时间：2024/04/29 16:00

The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The
SL_REP user executes this command to create a table:
SQL> CREATE TABLE orders(
oid number(6),
odate date,
ccode number(4),
oamt number(10,2)
)
TABLESPACE purchase_space;
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes the effect of the command?
A.The command executes successfully and creates the table in the USERS tablespace.
B.The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C.The command produces an error because the user does not have the privilege to create the table.
D.The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
答案：B
解析：从题目中已知信息
1.用户sl_rep没有锁
2.默认的表空间为user
3.具有resorce的角色,并且为default为Y，说明具有create table的权限
4.创建的表，指定表空间为purchase_space，并且存在
因此，会在purchase_space创建成功，选择B
D选项是错误，没有直接控制用户访问某个表空间的权限只能做到限制大小

0 0