129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
来源：互联网 发布：淘宝模特兼职的骗局 编辑：程序博客网 时间：2024/05/21 10:19
129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
Evaluate the following SQL statement:
SQL>SELECT p.promo_id, p.promo_name, s.prod_id
FROM sales s RIGHT OUTER JOIN promotions p
ON (s.promo_id = p.promo_id);
Which statement is true regarding the output of the above query?
A.It gives the details of promos for which there have been sales.
B.It gives the details of promos for which there have been no sales.
C.It gives details of all promos irrespective of whether they have resulted in a sale or not.
D.It gives details of product ID s that have been sold irrespective of whether they had a promo or not.
Evaluate the following SQL statement:
SQL>SELECT p.promo_id, p.promo_name, s.prod_id
FROM sales s RIGHT OUTER JOIN promotions p
ON (s.promo_id = p.promo_id);
Which statement is true regarding the output of the above query?
A.It gives the details of promos for which there have been sales.
B.It gives the details of promos for which there have been no sales.
C.It gives details of all promos irrespective of whether they have resulted in a sale or not.
D.It gives details of product ID s that have been sold irrespective of whether they had a promo or not.
答案：C
解析：right join 的用法
0 0
- 129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
- 149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
- 153.View the Exhibits and examine the structures of the PRODUCTS and SALES tables.
- 120.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
- 123.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
- 137.View the Exhibits and examine PRODUCTS and SALES tables.
- 124.View the Exhibit and examine the structure of the PROMOTIONS, SALES, and CUSTOMER tables.
- 168.View the Exhibit and examine the description of SALES and PROMOTIONS tables.
- 1.View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.
- 132.View the Exhibit and examine the structure of the SALES and PRODUCTS tables.
- 162.View the Exhibit and examine the structure of the PRODUCTS, SALES, and SALE_SUMMARY tables.
- 166.View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables.
- 164.View the Exhibit and examine the structure of CUSTOMERS and SALES tables.
- 154.View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.
- 161.View the exhibit and examine the description for the SALES and CHANNELS tables.
- 40.View the Exhibit to examine the description for the SALES and PRODUCTS tables.
- 56.View the Exhibit and examine the structure of the PROMOTIONS table.
- 61.View the Exhibit and examine the structure of the PROMOTIONS table.
- windows录音程序原理
- 深入理解Java：注解（Annotation）自定义注解入门
- Integer与int的种种比较你知道多少？
- 206. Reverse Linked List
- Ubuntu install Redis
- 129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
- UNICODE下CString 和 const char* 的相互转化
- 加油，启程！
- 堆排序
- TCP连接建立断开
- 算法训练 最大最小公倍数
- no matching provisioning profile found
- 抽象工厂模式
- 【Github教程】史上最全github使用方法：github入门到精通
