Oracle
1Z0-007 · Question #83
1Z0-007 Question #83: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.
Question
Examine the description of the CUSTOMERS table: The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?
Exhibit
Options
- ASELECT city_address, COUNT(*)
- BSELECT city_address, COUNT (*)
- CSELECT city_address, COUNT(customer_id)
- DSELECT city_address, COUNT (customer_id)
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 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.