• Description:NonStop Structured Query Language (SQL)
• Passing Score:75%
• Practice Test - Number of questions:145 questions
• Simulation Test - Number of questions:145 questions
• Simulation Test Duration:90 minutes
• Has explanations:No

Exhibit: The exhibit shows a query and the four tables it uses. The query will select data about orders by customers from California and _______.

Answer(s)

1. the price for the total quantity ordered is computed for each order number
2. the ORDERNUM and CUSTNUM are reported
3. the price for the total quantity ordered is computed for all orders
4. the ORDERNUM and PARTNUM are reported

the price for the total quantity ordered is computed for each order number