Ocp-1z0-051-Name Resolution-Article 12 title

Need to produce a the report where each customer's credit limit have been incremented by $1000. Inch
The output, the customer's last name should has the heading name and the incremented credit limit
Should is labeled New credit Limit. The column headings should has only the first letter of each word in uppercase.
Which statement would accomplish this requirement?

(Test instructions: You need to make a report in which the customer's credit limit is 1000 plus the name of the Customer Name field.) The title of the new credit limit is "new credit limit", and the three words are capitalized in the first letter. Which of the following statements meets the above requirements? )
A.
SELECT cust_last_name Name, Cust_credit_limit +
"New Credit Limit"
From customers;
B.
SELECT cust_last_name as name, Cust_credit_limit +
As New Credit Limit
From customers;
C.
Select Cust_last_name as "name", Cust_credit_limit +
As "New credit Limit"
From customers;
D.
Select Initcap (cust_last_name) "name", Cust_credit_limit +
initcap ("NEW credit LIMIT")
From customers;

Answer:b

Topic Analysis:

This question is about whether or not the field header has a double-reference, and the rules for using the two-argument are as follows:

1. Suppose that the field name is composed of multiple words, with spaces in between, such as new credit Limit. You must add a double argument, or you will get an error.
2. Assume that the title name is a word or multiple consecutive words. Assume no double-quotes. The format of the output is completely uppercase, such as option A, the name is output.
Assuming that the plus and minus arguments are output as-is, option C outputs the Name
In summary, so the correct answer to this question is C
The Initcap function in the D option is not available for field names. is a language method error.

Copyright notice: This article Bo Master original article. Blog, not reproduced without consent.

Ocp-1z0-051-Name Resolution-Article 12 title