PrepAway - Latest Free Exam Questions & Answers

What will happen if duplicates for a unique key get Inserted during the LOAD phase due to duplicates in the in

You are running a LOAD utility and have not provided an exception table.
What will happen if duplicates for a unique key get Inserted during the LOAD phase due to
duplicates in the input file?

PrepAway - Latest Free Exam Questions & Answers

A.
LOAD will eliminate the duplicate rows from the table and give a warning message.

B.
LOAD will fail and generate an error message.

C.
LOAD will create the exception table.

D.
LOAD will complete but the table being loaded will be placed in SET INTEGRITY
PENDING state


Leave a Reply