ocp認證題：1Z0-051-008題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp認證題：1Z0-051-008題：完整題庫請點擊這里聯系老師咨詢了解
8. View the Exhibit and examine the structure of the CUSTOMERS table.
Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)
A. listing of customers who do not have a credit limit and were born before 1980
B. finding the number of customers, in each city, whose marital status is 'married'
C. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
D. listing of those customers whose credit limit is the same as the credit limit of customers residing in the
city 'Tokyo'
E. finding the number of customers, in each city, whose credit limit is more than the average credit limit of
all the customers
Answer: DE
試題解析：
ABC不用子查詢就可以查詢出，題意選擇兩個，排除ABC,選擇DE
A. 列出沒有信貸限額并且1980年以前出生的客戶。
SELECT 客戶 from 表名 where 信貸限額 is null and 出生日期>1980;
B. 查找每個城市的已婚客戶的數量。
SELECT 城市名，COUNT(*) FROM 表名 where 客戶婚否=‘結婚’ group by 城市名;
C. 查找屬于'Tokyo'或者 'Sydney'兩個城市的男性客戶的平均信貸限額。
SELECT 城市名， AVG(信貸限額) from 表名 where 性別=‘男’ and 城市 in('Tokyo'， 'Sydney') group by 城市名
D 列出與'Tokyo'城市的客戶的信貸限額相等的客戶
E. 查找每個城市的客戶數量，這些客戶的信貸限額大于所有客戶的平均信貸限額。
