View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCEroles 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 ofthe 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_SPACEtablespace.
正确答案:B
答案解析:有

微信扫一扫手机做题