12.You need to produce a report where each customer's credit limit has been incremented by $1000. In
来源:互联网 发布:网络挣钱游戏 编辑:程序博客网 时间:2024/04/28 09:45
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") 这里的双引号使用错误,双引号只能用在数据结构名称上
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") 这里的双引号使用错误,双引号只能用在数据结构名称上
0 0
- 12.You need to produce a report where each customer's credit limit has been incremented by $1000. In
- 14.Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount
- 69.You need to generate a list of all customer last names with their credit limits from the CUSTOMER
- Solution to : The cpu has been disabled by the guest operating system. You will need to power off or reset the virtual machine a
- The CPU has been disabled by the guest operating system. You will need to power off or reset the vir
- The maximum report processing jobs limit configured by your system administrator has been reached
- Crystal report 出现maximum report processing jobs limit configured by your system administrator has been reached错误的解决办法.
- Crystal report 出现maximum report processing jobs limit configured by your system administrator has been reached错误的解决办法.
- 22.You need to create a table for a banking application. One of the columns in the table has the fol
- java.sql.SQLException: Your password has expired. To log in you must change it using a client that s
- Things you need to remember to become a successful developer (By Andriy Buday)
- Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant)
- Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant)
- Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant)
- Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant)
- Android运行异常二:Caused by: java.lang.IllegalStateException: You need to use a Them
- Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant)
- Caused by: java.lang.IllegalStateException: You need to use a Theme.AppCompat theme (or descendant)
- mybatis中的 $ 与 #的区别
- Root WebApplicationContext: initialization completed in 1039648 ms
- Codeforces Round#339 div1,div2
- Java内存模型FAQ(七)同步会干些什么呢
- Fusioncharts图表库更新至3.10.0版本
- 12.You need to produce a report where each customer's credit limit has been incremented by $1000. In
- FTP(FtpWebRequest/FtpWebResponse) 上传下载
- drawLine DashPathEffect绘制虚线变成了实线
- [译]Scala方法和函数的区别
- 什么是广告创意
- iOS textfield 限定输入的文本长度
- 【C#】反射应用-通过方法名调用方法
- unity 血条遮挡问题
- [angularJS]我的第一个angularJS应用——解决不执行controller的代码