Oracle 11g - 12c Sql Loader Interview Questions and Answers Pdf - 1
What is the SQL*Loader?
SQL Loader is a tool to lead data from file to a database table.
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.
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.
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.
Can you load data into multiple tables at once?
7000+ Direct and Indirect Speech worksheets with Answers More
7000+ Phrasal Verbs Quiz with Answers Pdf More
7000+ Multiple Choice Questions on Phrasal Verbs with Answers Pdf More
7000+ Linkers in English Grammar 2024 - 2025 Exercises Pdf More
7000+ Linkers and Connectors Exercises with Answers Pdf More
1000+ Engineering Mechanics Questions and Answers Pdf More
1000+ Permutation and Combination Questions for Bank Exams More
1000+ Hexaware Aptitude Questions and Answers 2023-2024 Pdf More
World Top Producing Countries and Main Produces/Industries in India More
1000+ Structural Engineering MCQ Questions and Answers Pdf More