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