OCP-1Z0-051-V9.02-12题

来源：互联网发布：java开源管理系统编辑：程序博客网时间：2024/05/22 03:20

12. You need to produce a report where each customer's credit limit has been incremented by $1000. In
the output, t he customer's last name should have the heading Name and the incremented credit limit
should be labeled New Credit Limit. The column headings should have only the first letter of each word in
uppercase .
Which statement would accomplish this requirement?
A.

SELECT cust_last_name Name, cust_credit_limit + 1000
"New Credit Limit"
FROM customers;

[sql] view plaincopyprint?
sh@TESTDB> SELECT cust_last_name Name, cust_credit_limit + 1000        
  2  "New Credit Limit"   
  3  FROM customers WHERE ROWNUM<6;   
  
NAME                                               New Credit Limit  
-------------------------------------------------- ----------------  
Ruddy                                                          2500  
Ruddy                                                          8000  
Ruddy                                                         12000  
Ruddy                                                          2500  
Ruddy                                                         10000  

SELECT cust_last_name AS Name, cust_credit_limit + 1000
AS New Credit Limit
FROM customers;

[sql] view plaincopyprint?
sh@TESTDB> SELECT cust_last_name AS Name, cust_credit_limit + 1000         
  2  AS New Credit Limit   
  3  FROM customers WHERE ROWNUM<6;   
AS New Credit Limit  
       *  
ERROR at line 2:  
ORA-00923: FROM keyword not found where expected  

SELECT cust_last_name AS "Name", cust_credit_limit + 1000
AS "New Credit Limit"
FROM customers;

[sql] view plaincopyprint?
<a target="_blank" href="mailto:sh@TESTDB">sh@TESTDB</a>> SELECT cust_last_name AS "Name", cust_credit_limit + 1000         
  2  AS "New Credit Limit"   
  3  FROM customers WHERE ROWNUM<6;   
  
Name                                               New Credit Limit  
-------------------------------------------------- ----------------  
Ruddy                                                          2500  
Ruddy                                                          8000  
Ruddy                                                         12000  
Ruddy                                                          2500  
Ruddy                                                         10000  

SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000
INITCAP("NEW CREDIT LIMIT")
FROM customers;

[sql] view plaincopyprint?
sh@TESTDB> SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000         
  2  INITCAP("NEW CREDIT LIMIT")   
  3  FROM customers WHERE ROWNUM<6;  
INITCAP("NEW CREDIT LIMIT")  
       *  
ERROR at line 2:  
ORA-00923: FROM keyword not found where expected  

此题要求选出列标题为Name和New Credit Limit，只有C满足。

A的Name应加双引号，原型输出

B/D语法错误

此题答案选C

0 0