试题详情
多项选择题 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
  • 关注下方微信公众号,在线模考后查看

热门试题