16.Evaluate the following query:
SQL> SELECT promo_name q'{'s start date was }' promo_begin_date AS "Promotion Launches"FROM promotions;
What wocould be the outcome of the above query?
A.It produces an error because flower braces have been used.
B.It produces an error because the data types are not matching.
C.It executes successfully and introduces an's at the end of each promo_name in the output.
D.It executes successfully and displays the literal "{'s start date was}" for each row in the output.
Answer: C
Question Analysis:
A: an error occurs because the curly braces are used (incorrect, the curly braces here are the Q-quote expressions)
B: an error occurs because the data type does not match (incorrect, irrelevant)
C: It will be executed correctly and an's will be added after each promo_name (correct, this is a Q-quote expression)
D: It will be correctly executed and the output string {'s start date was} (error) in each row)
For a detailed answer to this question refer to 13th question: http://blog.csdn.net/wjx515628/article/details/35278889