OCP-1Z0-051 第16题 Q操作符的用法

最新推荐文章于 2024-09-05 15:23:35 发布

hello_holly

最新推荐文章于 2024-09-05 15:23:35 发布

阅读量5.3k

点赞数

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 Q-quote q操作符 q转义

本文链接：https://blog.csdn.net/holly2008/article/details/23219925

版权

OCP-1Z0-051 专栏收录该内容

220 篇文章 6 订阅

订阅专栏

一、原题

Evaluate the following query:
SQL> SELECT promo_name q'{'s start date was }' promo_begin_date
AS "Promotion Launches"
FROM promotions;
What would 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

答案：C

二、题目翻译

下面的查询语句：
SQL> SELECT promo_name q'{'s start date was }' promo_begin_date
AS "Promotion Launches"
FROM promotions;
上面的查询语句输出什么内容？
A. 它产生一个错误，因为花括号被使用。
B. 它产生一个错误，因为数据类型不匹配。
C. 它会执行成功，并且每一个promo_name后面会输出一个’s.
D. 它会执行成功，并且每一行会显示" {'s start date was } "。