多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题