Oracle Database Administration from Zero to Hero - Using SQL Loader (Part 3 of 4)

What character does Linux use to represent the end of a line?

• Line feed

• Carriage return

• Tab

• Space

How does SQL Loader handle record terminators in CSV files?

• It ignores them

• It requires manual configuration

• It uses the STR option

• It automatically handles them

What is a common field termination character in CSV files?

• Semicolon

• Comma

• Colon

• Period

Which parameter is used to delete all rows from a table before loading new data?

• APPEND

• INSERT

• REPLACE

• TRUNCATE

What happens if the APPEND parameter is used in SQL Loader?

• Data is loaded only if the table is empty

• Existing data is replaced

• Table is truncated before loading

• Data is added without affecting existing data

What does the NULL IF clause do in SQL Loader?

• Converts null values to strings

• Ignores null values

• Replaces specific characters with null values

• Replaces null values with zeros

Which clause is used to apply conditions on data being loaded?

• CASE

• WHEN

• IF

• WHERE

How does SQL Loader treat missing data at the end of records?

• As an error

• As a null value

• As a blank space

• As a zero

What is the purpose of the INTO TABLE clause in SQL Loader?

• To determine the data format

• To define the table to load data into

• To set the file path

• To specify the database

In SQL Loader, what is the result of using multiple INTO TABLE clauses?

• Data is ignored

• Data is split across multiple tables

• Data is duplicated

• Data is loaded into a single table