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

Oracle认证考试

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

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

微信扫一扫手机做题