Which method is best suited for this quarterly data transfer?

The TRANS_SUMMARY table contains product-wise transaction details that get updated
with every transaction in the system. Each row has cumulative transaction details of a single
product and every product is identified by a product code, which is the primary key. As part
of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY
table to 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.
Which method is best suited for this quarterly data transfer?

The TRANS_SUMMARY table contains product-wise transaction details that get updated
with every transaction in the system. Each row has cumulative transaction details of a single
product and every product is identified by a product code, which is the primary key. As part
of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY
table to 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.
Which method is best suited for this quarterly data transfer?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *