问题题干答案解析相关问题热门问题最新问题

问题详情

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&ensp;the&ensp;RESOURCE&ensp;role&ensp;to&ensp;SCOTT.

B、Add&ensp;data&ensp;files&ensp;to&ensp;the&ensp;USERS&ensp;tablespace.

C、Grant&ensp;the&ensp;CREATE&ensp;ANY&ensp;TABLE&ensp;privilege&ensp;to&ensp;SCOTT.

D、Increase&ensp;the&ensp;space&ensp;for&ensp;SCOTT&ensp;on&ensp;the&ensp;USERS&ensp;tablespace.

E、Increase&ensp;the&ensp;size&ensp;of&ensp;the&ensp;data&ensp;file&ensp;associated&ensp;with&ensp;the&ensp;USERS&ensp;tablespace

时间：2022-01-05 13:29 关键词： 1Z0-052

答案解析

B| E

相关问题