Oracle
1Z0-034 · Question #39
1Z0-034 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Question
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, 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?
Options
- Aline 2, because the column names have been specified
- Bline 7, because file name must have a .dat extension
- Cline 3, because ORGANIZATION EXTERNAL has been specified
- Dline 9, because the PARALLEL option cannot be specified with one file name
- Eline 12, because there is no join defined between EMPLOYEES and DEPARTMENTS table
- Fline 5, because ORACLE_LOADER is not a valid structure for external table creation with the
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 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.