047-q1,

047-q1,
Zookeeper

QUESTION 1

You need to load information about new MERs from the NEW_CUST table into the tables CUST and CUST_SPECIAL. if a new customer has acredit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL.All new customer details have to be inserted into the CUST table. which technique shocould be used to load the data most efficiently?

A. external table

B. the MERGE command

C. the multitable INSERTcommand

D. INSERTusing WITH CHECK OPTION

Answer: C