In the customers table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘Abigail’.
Evaluate the following query:
What would be the outcome?
A.
Abigail PA
B.
Abigail Pa
C.
Abigail IS
D.
An error message
Explanation:
What would be the outcome?
In the customers table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘Abigail’.
Evaluate the following query:
What would be the outcome?
B
B
INITCAP is the last function
A
A
A
A
B, because UPPER is inside INITCAP