Which sql*loader load keyword deletes data in table before loading?
a. append
b. delete
c. substitute
d. replace

D. REPLACE

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.

i belive the answer you are looking for is d: the nether

hi, you. i think this we be deleted because it's a invalid question.

(i suggest no to do this in the