Oracle
1Z0-061 · Question #132
1Z0-061 Question #132: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-061 to reveal the answer and full explanation for question #132. The question stem and answer options stay visible for context.
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
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.