问题:
View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_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 theeffect 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.
View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_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 theeffect of the command()
● 参考解析
本题暂无解析
相关内容
相关标签