a2zinterviews

1.	What is the SQL*Loader?
	SQL Loader is a tool to lead data from file to a database table.
	Discuss 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.
	Discuss 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.
	Discuss Your Name Your Email-ID Your Answer

4.	Can you load data into multiple tables at once?
	Yes
	Discuss Your Name Your Email-ID Your Answer