PrepAway - Latest Free Exam Questions & Answers

Which two statements describe advantages of using an Optim Insert process instead of a Load process to populat

Which two statements describe advantages of using an Optim Insert process instead of a Load process to populate a test database? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
An Insert process can always insert all the data successfully regardless of the presence of complex referential integrity (RI) cycles.

B.
An Insert process allows other users to access the database while the insert is performed; a Load process may require exclusive control of the database.

C.
An Insert process allows for Update/Insert processing in one step; a Load process may not.

D.
An Insert process will be faster than a Load process when inserting large volumes of data.

E.
An Insert process allows you to use Column Maps to transform data; a Load process does not.


Leave a Reply