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.
正确答案:B
答案解析:有
微信扫一扫手机做题