16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
来源:互联网 发布:本地网络ip 编辑:程序博客网 时间:2024/06/09 10:02
16.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
解析:这个考察的也是q前缀,q前缀可以参考13题
A:错误,这里说花括号已经使用
B:错误,说是数据类型不匹配
C:正确
D:错误,说是会显示{'s start date was },肯定是不正确的
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
解析:这个考察的也是q前缀,q前缀可以参考13题
A:错误,这里说花括号已经使用
B:错误,说是数据类型不匹配
C:正确
D:错误,说是会显示{'s start date was },肯定是不正确的
0 0
- 16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
- 19.Evaluate the following query:
- 78.Evaluate the following query:
- ocp 047-141 Evaluate the following SQL statement:SELECT product_name || 'it's not available for orde
- 31.Evaluate the following SQL commands:
- 146.Evaluate the following SQL statement:
- 155.Evaluate the following SQL statement
- 156.Evaluate the following SQL statement:
- 126 You executed the following commands in a database session: SQL> SELECT object_name, original_nam
- The query does not start with a valid identifier, has to be either SELECT, UPDATE or DELETE FROM
- 30.Evaluate the following CREATE TABLE commands:
- 43.Evaluate the following CREATE SEQUENCE statement:
- 55.Evaluate the following two queries:
- 55.Evaluate the following two queries:
- 167.Evaluate the following DELETE statement:
- 191 You observed the following output for a user session: SQL > SELECT sid, event, seconds _in _wait
- 55.View the Exhibit to examine the output produced by the following query at three different times s
- A Source the following script
- 配置PLSQL Developer远程连接Oracle数据库
- CSS fon属性
- 实现ListView过滤功能,继承于BaseAdapter,非ArrayAdapter。
- POJ 2195Going Home(KM或费用流)
- 数据库关键字
- 16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
- 后台通过读取流的形式,实现下载功能
- Eclipse--Debug---断点调试
- ajax调用servlet,servlet内无法实现页面跳转
- JavaGUI-Swing
- Mongodb Profiler Output
- jQuery Mobile
- java synchronized详解
- 快捷键