Question

Which SQL*Loader load keyword deletes data in table before loading?

A. APPEND

B. DELETE

C. SUBSTITUTE

D. REPLACE

Answer 1

D. REPLACE

Step-by-step explanation:

The REPLACE command in SQL* Loader deletes the data in the table before loading the new content. The command is meant to update the entire table with new data and not individual row or rows. For modifying individual rows , SQL UPDATE command can be used.

APPEND is used to adding new rows to the data.

DELETE is a SQL operation for deleting one or more rows from the table.

SUBSTITUTE is not a valid keyword for SQL* LOADER.