C & E are correct - ..."SQL*Loader express mode generates a log file that includes a SQL*Loader control file. The log file also contains SQL scripts for creating the external table and performing the load using a SQL INSERT AS SELECT statement. Neither the control file nor the SQL scripts are used by SQL*Loader express mode. They are made available to you in case you want to use them as a starting point to perform operations using regular SQL*Loader or standalone external tables; the control file is for use with SQL*Loader, whereas the SQL scripts are for use with standalone external tables operations."
C and E are correct, wrong are:
A. SQL*Loader doesn't overwrite existing data in a table unless specified with the REPLACE option in the control file.
B. SQL*Loader uses direct path load method that bypasses the buffer cache and writes data blocks directly into the data files.
D. SQL*Loader doesn't generate a SQL script that it uses to load data. The loading operation is controlled by a control file, which is a text file that contains data loading instructions.
D is not correct.
It is true, that is generates a script, but "Neither the control file nor the SQL scripts are used by SQL*Loader express mode." while answer D states "...that it uses to load data..."
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader-express-mode.html#GUID-0F35B551-861B-450D-8BF3-2312893A67D7
This is tricky Question, as the Oracle documentation states:
A conventional Path insert takes the data in the source file and constructs Basic insert Statements using the individual source data as bind variables, These Statements are then then run against the table and data is inserted, the data is read into the Buffer Cache.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rivaldo11
Highly Voted 4 years, 6 months agoEkos
4 years, 1 month agoRafafm
Most Recent 3 months, 1 week agoOracle2020
1 year, 4 months agoauwia
1 year, 6 months agoRaNik69
1 year, 7 months agoBorislone
3 years, 6 months agoDatajimm
2 years, 10 months agoama
4 years, 6 months agoyou1234
4 years, 6 months ago