Multiple choice technology databases

What is SQL Loader?

  1. SQL LOADER utility is used to load data from other data source into Oracle.

  2. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables

  3. SQL Loader will only read the data from Flat files.

  4. If you want to load the data from Foxpro or any other database, first step is to convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data into Oracle.

  5. All the above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

SQL*Loader is an Oracle utility used to load data from external flat files. All individual options accurately describe its capabilities, limitations, and standard processes, making 'All the above' the correct choice.

Keep practicing — related questions