Examine the following command to create an external table from EMPLOYEES and
DEPARTMENTS database tables.
1. CREATE TABLE employee_ext
2. (employee_id, first_name, last_name, department_name)
3. ORGANIZATION EXTERNAL
4. (
5. TYPE ORACLE_LOADER
6. DEFAULT DIRECTORY ext_dir
7. LOCATION (’emp1.dmp’)
8. )
9. PARALLEL
10. AS
11. SELECT e.emplyee_id,e.first_name,e.last_name,d.department_name
12. FROM employees e, departments d;
Which line of the command would cause an error?
A.
line 2, because the column names have been specified
B.
line 3, because ORGANIZATION EXTERNAL has been specified
C.
line 7, because the file name must have a .dat extension
D.
line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS
tables
E.
line 9, because the PARALLEL option cannot be specified with one file name
F.
line 5, because ORACLE_LOADER is not a valid structure for external table creation with
the SELECT statement
Explanation: