Oracle
1Z0-061 · Question #132
View the Exhibit and examine the structure of the CUSTOMERS table. you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with…
The correct answer is C. It executes and shows the required result. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the structure of the CUSTOMERS table. you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name 'king' and whose credit limit is less than the maximum credit limit in countries that have customers with the last name 'king'. Which statement is true regarding the outcome of the above query?
Exhibit
Options
- AIt produces an error and the < operator should be replaced by < ANY to get the required output
- BIt produces an error and the IN operator should be replaced by = in the WHERE clause of the main
- CIt executes and shows the required result
- DIt produces an error and the < operator should be replaced by < ALL to get the required output
How the community answered
(36 responses)- A3% (1)
- B8% (3)
- C72% (26)
- D17% (6)
Community Discussion
No community discussion yet for this question.