Oracle 11g - 12c Sql Loader Interview Questions and Answers Pdf - 1
Question: 1
What is the SQL*Loader?
SQL Loader is a tool to lead data from file to a database table.
Question: 2
What is the difference between the conventional and direct path loads?
The direct path load loads data directly into datafiles while conventional path load uses standard insert statements.
There are a few restrictions with direct path loads. The data loaded using direct path does not replicate.
Question: 3
What is the difference between the SQL*Loader and import utilities?
Import and SQL*Loader both can be used to load data in a database.
However, import works in combination with export and can read files generated by export only.
SQL*Loader can read normal text files and you can explain the interpretation of text in the control file.
Question: 4
How you improve the performance of SQL*Loader?
You can use direct path load to improve the performance.
Indexes and constraints make inserts slow. Removing indexes and constraints improve performance of inserts; and therefore, of SQL*Loader.
Question: 5
Can you load data into multiple tables at once?
Yes
1000+ GRE Non Verbal Reasoning Questions and Answers Pdf More
1000+ Non Verbal Reasoning Grouping of Images Questions Pdf More
Non Verbal Reasoning Grouping of Identical Figures Questions More
1000+ Transformation of Sentences Worksheet with Answers Pdf More
1000+ Ethiopian Bank Interview Questions and Answers Pdf More
C++ Online Test | Questions and Answers for Gate 2020-2021 More
100+ SBI PO, SO, Clerk Previous Year Question Paper with Answers More
Top 100+ Astronomy Online Test Quiz Questions and Answer More
Science and Technology Online Test | Mock Test 2020-2021 More
1000+ Illumination MCQ Questions and Answers Pdf More