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?

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?

Accepted Answer

B. in the bad file

Answer

A. in the log file

Answer

C. in the control file

Answer

D. in the discard file

Answer

E. in the file set in the FILE option

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 \\…

Question

Exhibit

Options

How the community answered

Community Discussion