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
“New Credit Limit”
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;
Explanation:
A column alias:
– Renames a column heading
– Is useful with calculations
– Immediately follows the column name (There can also be the optional AS keyword between the
column name and the alias.)
– Requires double quotation marks if it contains spaces or special characters, or if it is case
sensitive.
Ans C does not give first letter of each word in uppercase
the column heading should have the first letter in upper case!
They do have the first letter in uppercase because in ans c because you put it in quotations so the column heading show properly
A AND C IS CORRECT
c IS THE CORRECT BECAUSE IN A THE NAME COLUMN IS IN UPPERCASE
you are right ..A & C are correct
Only C is correct because when SQL Plus display the Column Name it will display in UPPER CASE. All the Heading column is displayed in UPPER CASE. I think this is the point of this question !
Only C is the answer. It is not the option A because according with the sentences it shows Name, without double quote and it will display in UPPERCASE.