一道注塑成型技术难题解答，求解答！

来源：蜘蛛抓取(WebSpider) 时间：2017-08-14 06:45 标签： 李约瑟难题的解答
查看: 1699|回复: 3
047的一道题目求解答
论坛徽章:6
103. View the Exhibit and examine the structure of EMPLOYEES and JOB_HISTORY tables.
The EMPLOYEES table maintains the most recent information regarding salary, department, and job for
all the employees. The JOB_HISTORY table maintains the record for all the job changes for the
employees. You want to delete all the records from the JOB_HISTORY table that are repeated in the
EMPLOYEES table.
Which two SQL statements can you execute to accomplish the task? (Choose two.)
FROM job_history j
WHERE employee_id =
(SELECT employee_id
FROM employees e
WHERE j.employee_id = e.employee_id)
AND job_id = (SELECT job_id
FROM employees e
WHERE j.job_id = e.job_id);
FROM job_history j
WHERE (employee_id, job_id) = ALL
(SELECT employee_id, job_id
FROM employees e
WHERE j.employee_id = e.employee_id and j.job_id = e.job_id )
FROM job_history j
WHERE employee_id =
(SELECT employee_id
FROM employees e
WHERE j.employee_id = e.employee_id and j.job_id = e.job_id )
FROM job_history j
WHERE (employee_id, job_id) =
(SELECT employee_id, job_id
FROM employees e
WHERE j.employee_id = e.employee_id and j.job_id = e.job_id )
Answer: CD
我老是觉得C是不对的
认证徽章论坛徽章:67
C没问题啊，为什么觉得不对，找台机器试下就好了
论坛徽章:6
106. Which statement is true regarding the CUBE operator in the GROUP BY clause of a SQL statement?
A. It produces only aggregates for the groups specified in the GROUP BY clause.
B. It finds all the NULL values in the superaggregates for the groups specified in the GROUP BY clause.
C. It produces 2 n possible superaggregate combinations, if the n columns and expressions are specified
in the GROUP BY clause.
D. It produces n+1 possible superaggregate combinations, if the n columns and expressions are specified
in the GROUP BY clause.
C应该是2的n次方吧，不是2n,迷惑得很
论坛徽章:6
hello ,will any one give a reply about the above question?
itpub.net All Right Reserved. 北京皓辰网域网络信息技术有限公司版权所有　　　　
　北京市公安局海淀分局网监中心备案编号：　广播电视节目制作经营许可证：编号（京）字第1149号一道经典题目求解的心路历程_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
一道经典题目求解的心路历程
阅读已结束，下载文档到电脑
想免费下载更多文档？
定制HR最喜欢的简历
你可能喜欢一道英语题求解，谢谢！！
本回答由提问者推荐后使用快捷导航没有帐号？
查看: 1073|回复: 5
在线时间 小时
XDF白勇语法全解P101.34题，求解？！[Japan received huge sums of capital from the United States after the Second World War, using it to help build] a modern industrial system.A. ...B. Japan received huge sums of capital from the United States after the second War and used it to help in buildingc. Japan used the huge sums of capital it received from United States after the Second World War to help buildD. Japan's huge sums of capital received from the United States after the Second World war were used to help it in helpingE. Receiving huge sums of capital from the United States after the Second World war, Japan used it to help build【答案】C正确书上说it在语法上指代美国，在逻辑上指代资本，产生了矛盾，于是ABE错。D的it语法上指代美国，逻辑上指代日本，于是矛盾，也错。E的recieve和use同时发生，逻辑上是先receive后use的。但是，我们明明知道it是指代的captial，还要装作不知道，认为他指代的是美国么。。。好自欺欺人啊。。不能够说服自己。。求救，类似问题困扰已久
在线时间 小时
有一个问题我不确定，huge sums of capital 好像应该用复数指代，如果是这样，书上解释很正常~ 因为it/they/them的指代是整个词组，不是单独一个词~
在线时间 小时
确实你的“明明知道”就是所谓的逻辑上指代capital，它和语法规则上不符合所以错啊。gmat是正式用语不是口语，当然不能只注重表面意思，就像我们作文里不能用口语要用书面语一样。
在线时间 小时
huge sums of capital 算单数还是复数呢？书上举例，Several tons of stone were quarried in France. 此时算复数，书上说：数词+单位词复数 of 不可数名词/物质名词+谓语动词用复数 我想这道题是类似的，谓语动词也要用复数所以代词是不是也要用复数啊？
在线时间 小时
有一个问题我不确定，huge sums of capital 好像应该用复数指代，如果是这样，书上解释很正常~ 因为it/they/them的指代是整个词组，不是单独一个词~-- by 会员 yiqing2012 ( 0:23:37)
huge sums of capital 算单数还是复数呢？书上举例，Several tons of stone were quarried in France. 此时算复数，书上说：数词+单位词复数 of 不可数名词/物质名词+谓语动词用复数 我想这道题是类似的，谓语动词也要用复数所以代词是不是也要用复数啊？
在线时间 小时
有一个问题我不确定，huge sums of capital 好像应该用复数指代，如果是这样，书上解释很正常~ 因为it/they/them的指代是整个词组，不是单独一个词~-- by 会员 yiqing2012 ( 0:23:37)
huge sums of capital 算单数还是复数呢？书上举例，Several tons of stone were quarried in France. 此时算复数，书上说：数词+单位词复数 of 不可数名词/物质名词+谓语动词用复数 我想这道题是类似的，谓语动词也要用复数所以代词是不是也要用复数啊？-- by 会员 godhoo ( 11:10:25)
如果确是如此，那么是要用复数指代~GMAT中代词指代只有两个原则：指代前面出现过的单复一致。只要掌握这两个原则就可以，其它更多更细的原则，比如所有格中不能指代，介词结构中不能指代等原则一般都有例外，所以不要太纠结于其上~
所属分类: GMAT考试
正在浏览此版块的会员 ()
ChaseDream 论坛
All Rights Reserved.匿名用户不能发表回复！|
每天回帖即可获得10分可用分！小技巧：
你还可以输入10000个字符
(Ctrl+Enter)
请遵守CSDN，不得违反国家法律法规。
转载文章请注明出自“CSDN（www.csdn.net）”。如是商业用途请联系原作者。

我要回帖

更多关于 李约瑟难题的解答 的文章

 

随机推荐