Oracle SQL Loader Interview Question and Answers

1. What is the SQL*Loader?
  SQL Loader is a tool to lead data from file to a database table.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
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.
 
Your Name Your Email-ID
Your Answer
4. Can you load data into multiple tables at once?
  Yes
 
Your Name Your Email-ID
Your Answer
123 Page 1 of 3