1Z0-060 · Question #57
Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?
The correct answer is B. The SQL* Loader data file myfile1.dat has the column names for the EMP table. C. The SQL* Loader operation fails because no record terminators are specified. E. The SQL* Loader operation assumes that the file must be a stream record format file with the normal. SQL*Loader does not create tables, defaults to stream record format when no format is specified, and can source column names from the data file based on control file directives.
Question
Examine the contents of SQL loader control file:
Which three statements are true regarding the SQL* Loader operation performed using the control file?
Exhibit
Options
- AAn EMP table is created if a table does not exist.
- BThe SQL* Loader data file myfile1.dat has the column names for the EMP table.
- CThe SQL* Loader operation fails because no record terminators are specified.
- DField names should be the first line in the both the SQL* Loader data files.
- EThe SQL* Loader operation assumes that the file must be a stream record format file with the normal
How the community answered
(25 responses)- A20% (5)
- B72% (18)
- D8% (2)
Why each option
SQL*Loader does not create tables, defaults to stream record format when no format is specified, and can source column names from the data file based on control file directives.
SQL*Loader is a data loading utility with no DDL capability - it requires the target table to already exist and will return an error if the EMP table is absent rather than creating it.
When the SQL*Loader control file references columns by name and instructs the loader to read field headings from the data file, the first record of myfile1.dat serves as the column name source for the EMP table load.
Without a TERMINATED BY clause or explicit record format definition in the control file, SQL*Loader cannot determine record boundaries in a fixed-format or delimited file and will fail to parse the input correctly.
Column names are not required in both data files simultaneously - whether field names appear in a data file depends on the specific INFILE and FIELDS directives for each file defined in the control file.
SQL*Loader defaults to stream record format when no INFILE record format clause is provided, treating newline characters as the standard record delimiter on the operating system platform.
Concept tested: SQL*Loader control file behavior and record format defaults
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader-concepts.html
Topics
Community Discussion
No community discussion yet for this question.
