ocp考試題庫：11g-1Z0-051-v9.02-014題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp考試題庫：11g-1Z0-051-v9.02-014題，完整題庫請點擊這里聯系老師咨詢了解
14. Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit
amount in each income level. The report should NOT show any repeated credit amounts in each income
level. --each income level中沒有重復的credit amounts
Which query would give the required result?
A.
SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50
AS "50% Credit Limit"
FROM customers;
[sql] view plain copy print?
sh@TESTDB> SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50
2 AS "50% Credit Limit"
3 FROM customers;
SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50
*
ERROR at line 1:
ORA-00936: missing expression
語法錯誤，DISTINCT不應該放在第二列，應該放在第一列中
[sql] view plain copy print?
sh@TESTDB> SELECT DISTINCT cust_income_level,cust_credit_limit * 0.50
2 AS "50% Credit Limit"
3 FROM customers where rownum<6;
CUST_INCOME_LEVEL 50% Credit Limit
------------------------------ ----------------
G: 130,000 - 149,999 5500
G: 130,000 - 149,999 4500
G: 130,000 - 149,999 3500
G: 130,000 - 149,999 750
B.
SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50
AS "50% Credit Limit"
FROM customers;
同A，語法錯誤，DISTINCT不應該放在第二個
[sql] view plain copy print?
SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50
2 AS "50% Credit Limit"
3 FROM customers;
SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50
*
ERROR at line 1:
ORA-00936: missing expression
C.
SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50
AS "50% Credit Limit"
FROM customers;
[sql] view plain copy print?
sh@TESTDB> SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50
2 AS "50% Credit Limit"
3 FROM customers;
SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
這道題愿意為用' '連接兩個列，可能用錯，應為||來連接，不過DISTINCT的位置 對的
[sql] view plain copy print?
sh@TESTDB> SELECT DISTINCT cust_income_level || cust_credit_limit * 0.50
2 AS "50% Credit Limit"
3 FROM customers where rownum<6;
50% Credit Limit
----------------------------------------------------------------------
G: 130,000 - 149,999750
G: 130,000 - 149,9994500
G: 130,000 - 149,9993500
G: 130,000 - 149,9995500
D.
SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit"
FROM customers
D沒有滿足NOT show any repeated的條件。
此題答案C
