58.The PART_CODE column in the SPARES table contains the following list of values:
来源:互联网 发布:软件开发工作流 编辑:程序博客网 时间:2024/06/13 13:08
58.The PART_CODE column in the SPARES table contains the following list of values:
PART_CODE
A%_WQ123
A%BWQ123
AB_WQ123
Evaluate the following query:
SQL> SELECT part_code FROM spares WHERE part_code LIKE '%\%_WQ12%' ESCAPE '\';
Which statement is true regarding the outcome of the above query?
A.It produces an error.
B.It displays all values.
C.It displays only the values A%_WQ123 and AB_WQ123 .
D.It displays only the values A%_WQ123 and A%BWQ123 .
E.It displays only the values A%BWQ123 and AB_WQ123.
答案:D
解析:ESCAPE 后面的字符为转义字符,%\%_WQ12%,因此第一个%为模糊匹配然后是转义字符\,转义的是%,因此选择带有%号的
所以,排除ABCE,因此选择D,"_"为匹配任意一个字符
PART_CODE
A%_WQ123
A%BWQ123
AB_WQ123
Evaluate the following query:
SQL> SELECT part_code FROM spares WHERE part_code LIKE '%\%_WQ12%' ESCAPE '\';
Which statement is true regarding the outcome of the above query?
A.It produces an error.
B.It displays all values.
C.It displays only the values A%_WQ123 and AB_WQ123 .
D.It displays only the values A%_WQ123 and A%BWQ123 .
E.It displays only the values A%BWQ123 and AB_WQ123.
答案:D
解析:ESCAPE 后面的字符为转义字符,%\%_WQ12%,因此第一个%为模糊匹配然后是转义字符\,转义的是%,因此选择带有%号的
所以,排除ABCE,因此选择D,"_"为匹配任意一个字符
0 0
- 58.The PART_CODE column in the SPARES table contains the following list of values:
- 77.In the CUSTOMERS table, the CUST_CITY column contains the value 'Paris' for the
- 3.You need to extract details of those products in the SALES table where the PROD_ID column contains
- This page contains the following errors: error on line 1 at column 1: Extra content at the end of t
- 82.Examine the data in the CUST_NAME column of the CUSTOMERS table.
- 83.Examine the data in the CUST_NAME column of the CUSTOMERS table.
- 101.Examine the data in the PROMO_BEGIN_DATE column of the PROMOTIONS table:
- 75.The following data exists in the PRODUCTS table:
- Refreshing One Column based on the value of Another Column in ADFdi Table
- values in the legend
- ocp 047-40 User OE, the owner of the ORDERS table, issues the following command:
- org.dom4j.DocumentException: Error on line 1 of document : The markup in the document following the
- An explicit value for the identity column in table 'users' can only be specified when a column list
- the currently displayed page contains invalid values
- the currently displayed page contains invalid values
- The currently displayed page contains invalid values
- The currently displayed page contains invalid values
- the currently displayed page contains invalid values
- linux中的前台任务、后台任务和守护进程
- 使用Java构建微服务
- 请教大家关于wireshark添加lua自定义规则解析模块的问题
- PHP 单一入口
- HDU 1434 幸福列车 (附优先队列讲解)
- 58.The PART_CODE column in the SPARES table contains the following list of values:
- 网卡接口相关定义
- Leetcode:237. Delete Node in a Linked List(JAVA)
- 用户管理系统——添加用户
- 《Android开发精要》读书笔记——Android的系统架构
- openGL之深度测试、表面剔除、剪裁---openGL学习笔记(五)
- EXP/IMP迁移数据库的时候注释乱码解决方法
- Ajax 整体结构
- 转换人民币大写