Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables. CREATE TABLE employee_ext (employee_id, first_name, department_name) ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY ext_dir LOCATION (‘emp1.dmp’)) PARALLEL AS SELECT e.emplyee_id, e.first_name, e.last_name, d.department_name 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 7, because file name must have a .dat extension
c. line 3, because ORGANIZATION EXTERNAL has been specified
d. line 9, because the PARALLEL option cannot be specified with one file name
Verified Answer
Correct Option - f

To get all Infosys Certified Oracle 10g Database Administrator Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in