Oracle
1Z0-061 · Question #303
1Z0-061 Question #303: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #303. The question stem and answer options stay visible for context.
Question
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: SQL>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.)
Exhibit
Options
- AJOIN
- BFULL OUTER JOIN
- CLEFT OUTER JOIN
- DRIGHT OUTER JOIN
Unlock 1Z0-061 to see the answer
You've previewed enough free 1Z0-061 questions. Unlock 1Z0-061 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.