多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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. Whichmethod 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
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题