QUESTION 80
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
Correct Answer: A
使用MERGE命令可在一个命令中执行UPDATE 和INSERT 。可将一个源中的数据合并到另一个源，因而可选择插入新行和更新特定列（如果行已经存在）。
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
Correct Answer: A
这道题的意思是将TRANS_SUMMARY里的数据合并到TRANS_SUMMARY_DUP表里，如果TRANS_SUMMARY_DUP有存在的产品，则保留，如果是新产品，则插入。
使用MERGE命令可在一个命令中执行UPDATE 和INSERT 。可将一个源中的数据合并到另一个源，因而可选择插入新行和更新特定列（如果行已经存在）。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2102724/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-052 V12.49 Q31
下一篇：
1Z0-052 V12.49 Q112
请登录后发表评论
登录
全部评论
