12.You need to produce a report where each customer's credit limit has been incremented by $1000. In

最新推荐文章于 2020-08-06 09:02:59 发布

今年我18

最新推荐文章于 2020-08-06 09:02:59 发布

阅读量1.7k

点赞数

分类专栏： 1z0-051 文章标签： 1z0-051 oracle

本文链接：https://blog.csdn.net/dwj19830118/article/details/50543658

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

12.You need to produce a report where each customer's credit limit has been incremented by $1000. In
the output, the 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 FROM customers;
B.SELECT cust_last_name AS Name, cust_credit_limit + 1000 AS New Credit Limit FROM customers;
C.SELECT cust_last_name AS "Name", cust_credit_limit + 1000 AS "New Credit Limit" FROM customers;
D.SELECT INITCAP(cust_last_name) "Name", cust_credit_limit + 1000 INITCAP("NEW CREDIT LIMIT") FROM customers;
答案：C
解析：这道题考察的数据结构命名
1.数据结构命名只能是数字，字母，$,_,#，必须字母开头，长度不能超过30个字符，如果包括其他字符的时候使用""括起来
就可以了，但是长度不能超过30个字符，
2.如果不加"",那么数据结构的名字都会变成大写
A：错误，Name会变成NAME
B：错误，Name会变成NAME
C：正确
D：错误，INITCAP("NEW CREDIT LIMIT") 这里的双引号使用错误，双引号只能用在数据结构名称上