The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code, which is the primary key. <br /> As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products,the company deals with many new products during every quarter. <br /> Which method is best suited for t
A、using the MERGE command
B、using the SQL*Loader utility
C、using the correlated UPDATE command
D、using the INSERT command to perform bulk operation