Which statement would accomplish this requirement?

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?

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.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


reach

reach

Ans C does not give first letter of each word in uppercase

dj

dj

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

JTS

JTS

A AND C IS CORRECT

JTS

JTS

c IS THE CORRECT BECAUSE IN A THE NAME COLUMN IS IN UPPERCASE

dibsy

dibsy

you are right ..A & C are correct

Bogdan

Bogdan

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 !

Jenny

Jenny

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.