In which two scenarios do you use SQL* Loader to load data?
A.
Generate unique sequential key values in specified columns.
B.
Transform the data while it is being loaded into the database.
C.
Use transparent parallel processing without having to split the external data first.
D.
Load data into multiple tables during the same load statement.
AD
A,C
acctually A,B,C
A: SQL*Loader Support for Direct-Path Loading of Identity Columns
B: SQL*Loader External Table Load mode
C: SQL*Loader Parallel Direct Path mode
B and C are incorrect, for the reason that you would use external tables before SQL*Loader in both cases:
https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_concepts.htm
“In the following situations, use external tables for the best load performance:
You want to transform the data as it is being loaded into the database.
You want to use transparent parallel processing without having to split the external data first.”
Same link for A and D being correct, directly from Oracle documentation:
“SQL*Loader Features
SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. You can use SQL*Loader to do the following:
….
Load data into multiple tables during the same load session.
…
Generate unique sequential key values in specified columns.”
Therefore, A and D are correct.
I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get bought an nervousness over that you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly a lot often inside case you shield this increase.|
ad
http://docs.oracle.com/cd/B28359_01/server.111/b28319/ldr_concepts.htm#i1004619
AD
http://docs.oracle.com/database/121/SUTIL/GUID-289C0B1B-96FE-430B-8525-AC077E434DA9.htm#SUTIL1000