OCP 1Z0 051 132

（132）View the Exhibit and examine the structure of the SALES and PRODUCTS tables.

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table, You want to list each product ID and the number of times it has been sold.

Evaluate the following query:

SELECT p.prod_id, COUNT(s.prod_id) FROM products p_________sales s ON p.prod_id   = s.prod_id GROUP BY p.prod_id;

Which two JOIN options can be used in the blank in the above query to get the required output? (Choose two.)



A. JOIN

B. FULL OUTER JOIN

C. LEFT OUTER JOIN

D. RIGHT OUTER JOIN

答案：（B、C）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1169639/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1169639/