中国唯一一家专业只做ARACLE认证和BDA实训的甲骨文金牌合作企业
中国唯一一家专业只做ARACLE认证和BDA实训的甲骨文金牌合作企业
OCP 11g认证题库详解：1Z0-051-064题，，完整题库请点击这里联系老师咨询了解
64. View the E xhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of
the PROMOTIONS table.
Evaluate the following two queries:
SQL>SELECT DISTINCT promo_category to_char(promo_cost)"code"
FROM promotions
ORDER BY code;
SQL>SELECT DISTINCT promo_category promo_cost "code"
FROM promotions
ORDER BY 1;
Which statement is true regarding the execution of the above queries?
A. Only the first query executes successfully.
B. Only the second query executes successfully.
C. Both queries execute successfully but give different results.
D. Both queries execute successfully and give the same result.
Answer: B
试题解析：
order by 可以指定表达式、别名或列位置作为排序条件，别名要完全匹配
列别名并没有完全匹配，所以报错。
CUUG 优技培训
CUUG －CHINA UNIX USER GROUP，是国际UNIX组织UNIFORUM的中国代表，是国内悠久的专业UNIX培训机构，被誉为中国UNIX 的摇篮。金牌讲师
实操环境
院校合作
学校新闻
行业新闻
请输入您的手机号
申请试听
