Oracle
1Z0-052 · Question #189
1Z0-052 Question #189: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #189. The question stem and answer options stay visible for context.
Managing Database Storage Structures
Question
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following 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. (Choose two.)
Options
- 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.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ORA-01653#tablespace extension#datafile sizing#user quota