可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

User SCOTT wants to&en


User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error 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 either of which will help you resolve this problem.()

  • AGrant the RESOURCE role to SCOTT.
  • BAdd data files to the USERS tablespace.
  • CGrant the CREATE ANY TABLE privilege to SCOTT.
  • DIncrease the space for SCOTT on the USERS tablespace.
  • EIncrease the size of the data file associated with the USERS tablespace
参考答案
参考解析:
分类:1Z0-052题库