052-227(新增70题2018)

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?

Exhibit:

A. The user A does not have space quota.

B. RESOURCE role has not been granted to user A.

C. User A does not have insert privilege on EMP_DEP table.

D. The EMP_DEP table is residing on a temporary tablespace.

E. The default tablespace of user A does not have enough free space.

F. The tablespace where EMP_DEP table resides does not have enough free space.

Answer: F

ORA-01653: unable to extend table string.string by string in tablespace string

Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

说明表空间空间不足。

转载于:https://www.cnblogs.com/Babylon/p/8618155.html