Exhibit: View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and
EMP_DEP tables. User A wants to insert rows from EMPLOYEES and DEPARTMENTS
table into EMP_DEP table by using following insert command. INSERT INTO EMP_DEP
(emp_id,name,salary,dep_name,mgr_id) SELECT e.employee_id, e.first_name ||’ ‘||
e.last_name, e.salary, d.department_name, e.manager_id FROM employees e,
departments d where e.department_id = d.department_id; While user A executes the
command, it errors out, displaying the following error message: INSERT INTO EMP_DEP
(emp_id,name,salary,dep_name,mgr_id) * ERROR at line 1: ORA-01653: unable to allocate
extent table A.EMP_DEP by 8 in tablespace USERS What would have caused the error?
A.
The tablespace where EMP_DEP table resides does not have enough free space.
B.
The user A does not have space quota.
C.
RESOURCE role has not been granted to user A.
D.
User A does not have insert privilege on EMP_DEP table.
E.
The EMP_DEP table is residing on a temporary tablespace.
F.
The default tablespace of user A does not have enough free space.
Explanation: