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

Oracle认证考试

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

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session, create table TO user01; While executing the command to create a table, the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1: ORA-01950: no privileges on tablespace  What could be the possible reason for this error message?()

  • A、The tablespace TBS1 is full.
  • B、The user is not the owner of the SYSTEM tablespace.
  • C、The user does not have quota on the TBS1 tablespace.
  • D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
  • E、The user does not have sufficient privileges to create table on the default permanent tablespace.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题