Oracle
1Z0-032 · Question #4
1Z0-032 Question #4: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-032 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Question
View the Exhibit and examine the structure of the LDR_TEST table: To load data into the table, you execute the following SQL*Loader command: Oracle 1Z0-032 Exam $ sqlldr test/test \ control=test01.ctl \ log=test01.log \ bad=test01.bad \ discard=test01.dis \ errors=20 \ file=test.dbf While loading the data into the LDR_TEST table, you realize that the length of some values in the input data file is more than the width defined in the table for COL2 and because of this those records are not loaded into the table. In which file would you find the records that are not loaded?
Exhibit
Options
- Ain the log file
- Bin the bad file
- Cin the control file
- Din the discard file
- Ein the file set in the FILE option
Unlock 1Z0-032 to see the answer
You've previewed enough free 1Z0-032 questions. Unlock 1Z0-032 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.