OCP-1Z0-051-V9 02-124题
124. View the Exhibit and examine the structure of the PROMOTIONS,SALES,and CUSTOMER tables. You need to generate a report showing the promo name along with the customer name for all products that were sold?during their promo campaign and before 30th October 2007. You issue the following query: ? SQL> SELECT promo_name,cust_name? ? ? ?
FROM promotions p JOIN sales s
? ? ? ? ?
ON(time_id BETWEEN promo_begin_date AND promo_end_date)????????? JOIN customer c????????? ON (s.cust_id = c.cust_id) AND time_id < ‘30-oct-2007‘; Which statement is true regarding the above query?? ? A. It executes successfully and gives the required result. B. It executes successfully but does not give the required result. C. It produces an error because the join order of the tables is incorrect. D. It produces an error because equijoin and nonequijoin conditions cannot be used in the same SELECT statement. Answer: B 答案解析: 参考:http://www.voidcn.com/article/p-anbuhpzg-bbu.html ? 题意要求:需要一个报表,显示所有产品的promo name和customer name,销售的产品是在promo campaign之内,并且在2007年10月30日以前 ?缺少条件,?promotions p JOIN sales s? 之间应该有个PROMO_ID的等值连接,才能得出正确结果。 再分享一下我老师大神的人工智能教程吧。零基础!通俗易懂!风趣幽默!希望你也加入到我们人工智能的队伍中来!http://www.captainbed.net (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |