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
答案解析:有
微信扫一扫手机做题