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

Solve. 7/8p-1/4=1/2p
A book store bought 160 copies of a book from the publisher for 4,000. If the store gives away 2 books, how much money will it lose?
Just turn around to solve this challenge 09:009
How do you find the derivative of y=tan(arcsin(x))y=tan(arcsin(x)) ?
WHAT ADVANTAGES  DOES A GLOBE HAVE OVER A MAP OR SATELLITE IMAGE
At the zoo there were 3 times as many monkeys as lions. Tom counted a total of 24 monkeys and lions. How many monkeys were there ?
How do you find the derivative of y=arcsin(2x+1)y=arcsin(2x+1)?
Can someone help me: 4n-3=-2n+15
Reduce the fraction completely.96/53
Write an equation to represent each relationship. Then solve the equation.34. Three times the sum of a number and 4 is the same as 18 more than the number.36.