ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

57 / 120

Question 57:

View the exhibit and examine the structure of the CUSTOMERS table. 
image
Which two tasks would require subqueries or joins to be executed in a single statement? 

Answer options:

A. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
B. finding the average credit limit of male customers residing in `Tokyo` or `Sydney`
C. listing of customers who do not have a credit limit and were born before 1980
D. finding the number of customers, in each city, whose marital status is `married`.
E. listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city `Tokyo`.