jkgtmhuip1589 jkgtmhuip1589
  • 20-08-2019
  • Computers and Technology
contestada

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

A. APPEND

B. DELETE

C. SUBSTITUTE

D. REPLACE

Respuesta :

Branta Branta
  • 21-08-2019

Answer:

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.

Answer Link

Otras preguntas

What is the constant of proportionality in the equation, Y=4.50x?
Which nation is made up of four main islands (Honshu, Hokkaido, Kyushu, and Shikoku) and thousands of smaller islands?
When presented with a threatening stimulus, the brain processes the information along two different pathways: the fast pathway goes from the thalamus directly t
36 hundredths divided 9 tenths
Astrid, a customer service representative with NorthTel Wireless Services, was asked by one of her customers if NorthTel would be interested in joining the cham
Zen W Inc., a publication house, has posted an advertisement inviting applicants to pursue a role as a graphic designer. The company has specified that the job
Find the volume of the right cone. a 7560 cm3 b 30,200 cm3 c 11,300 cm3 d 22,700 cm3
Which of the following processes is not characteristic of all living things?
6 less than the product of 8 and a number n is 34
Can someone please help me answer this