179.The TRANS_SUMMARY table contains product-wise transaction details that get updated with every tr
来源:互联网 发布:网络实时音视频传输 编辑:程序博客网 时间:2024/06/14 01:08
179.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
答案:A
解析:
merge事例
merge into tbhuman d
using (select humanid from tbrolehuman)s on ( s.humanid=d.humanid)
when matched then
update set d.humanname='wahaha';
when not matched then
insert (d.humanid,d.humanname) values (s.humanid,'wahaha')
end;
这道题没看懂是要干啥
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
答案:A
解析:
merge事例
merge into tbhuman d
using (select humanid from tbrolehuman)s on ( s.humanid=d.humanid)
when matched then
update set d.humanname='wahaha';
when not matched then
insert (d.humanid,d.humanname) values (s.humanid,'wahaha')
end;
这道题没看懂是要干啥
0 0
- 179.The TRANS_SUMMARY table contains product-wise transaction details that get updated with every tr
- 127.Identify the two situations in which the alert log file is updated with details. (Choose two.)
- CareerCup Fill the array with product of all numbers except the number in that cell
- 3.You need to extract details of those products in the SALES table where the PROD_ID column contains
- The configuration file "vmname.vmx" was created by a VMware product that is incompatible with this v
- Find document with array that contains a specific value
- InfoPath error : "a dataset that contains a table name that is defined more than once"
- [iOS]Your package contains a file 'XXX.app/ XXX' with a name that contains leading or
- "Your package contains a file with a name that contains leading or trailing whitespace"解决方法
- database transaction simple details
- Java ArrayList contains details.
- Hibernate: prevent update of dirty instances that were never updated manually in the session
- find a subarray that contains the largest sum, constraint that sum is less than k
- What are the numbers that every computer engineer should know, according to Jeff Dean?
- The project contains another dependency with the same archive name.
- Updated JDOM with JXL
- The apps that get featured on the iOS App Store
- JS How to get the div that sends the event
- 梳理caffe代码loss(二十二)
- 简单Java类多对多映射
- 如何实现定时执行php的程序
- eclipse搭建andriod开发环境
- Java中对象比较(第三个代码模型)
- 179.The TRANS_SUMMARY table contains product-wise transaction details that get updated with every tr
- 解决:Error:Execution failed for task app:predexdebug
- 图片瀑布展示 web开发
- 【HDU 杭电 2059 龟兔赛跑】
- Java容器小解析
- 各种CSS布局总结
- Windows 64位下安装Redis超详细教程
- Java中 包装类与字符串之间的转化
- MySQL快速入门13----SQL编程