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

Oracle认证考试

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

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted:INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) *ERROR at line 1: ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. ()

  • A、Grant the RESOURCE role to SCOTT.
  • B、Add data files to the USERS tablespace.
  • C、Grant the CREATE ANY TABLE privilege to SCOTT.
  • D、Increase the space for SCOTT on the USERS tablespace.
  • E、Increase the size of the data file associated with the USERS tablespace
正确答案:B,E
答案解析:
进入题库查看解析

微信扫一扫手机做题