网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在SQL中，下列涉及通配符的操作，匹配范围最大的是（）。
- A、name LIKE ´hgf_´
- B、name LIKE ´hgf%´
- C、name LIKE ´hgf_t%´
- D、name LIKE ´h%´
参考答案
更多 “在SQL中，下列涉及通配符的操作，匹配范围最大的是（）。A、name LIKE ´hgf_´B、name LIKE ´hgf%´C、name LIKE ´hgf_t%´D、name LIKE ´h%´” 相关考题
考题
Nowadays teenagers like to go to the fast food restaurants,() as the name says, eating doesn’t take much time.
A、whichB、whoC、whatD、where
考题
●已知有关系模式R(S_NO，S_NAME，AGE)，其中S-NO表示学生的学号，类型为Char[8]，前4位表示入学年份。查询所有2005年入学的学生姓名(S_NAME)，SQL语句是 (24) 。(24) A．SELECT S_NAME FROM R WHERE S_NO=′2005％′B．SELECT S_NAME FROM R WHERE S_NO LIKE ′2005％′C．SELECT S_NAME FROM R WHERE S_NO=′2005%′D．SELECT S_NAME FROM R WHERE S_NO ′2005%′
考题
要查询Information表中学生姓中含有“张”的学生情况，可以用下列哪个命令?——A．SELECT* FROM Information WHERE s—Flame=‘张’B．SELECT*FROM Information WI-IERE s—name LIKE‘张％’C．SELECI*FROM Information WHERE s．_name LIKE‘张一’D．SEt,ECT*FROM Information WHERE s—name LIKE‘％张％’
考题
哪些是正确的 like 运算表达式？A.select * from net_46 where s_name like ’晓’B.select * from net_46 where s_name like ’&晓&’C.select * from net_46 where s_name like ’$晓$’D.select * from net_46 where s_name like ’%晓%’
考题
Do you know the name of that ( ) insect
A、red little funny bee-likeB、little funny bee-like redC、little bee-like funny redD、funny little red bee-like
考题
已知有关系模式及(S_N0，S_NAME,AGE)，其中S_NO表示学生的学号，类型为Char[8]，前4位表示入学年份。查询所有2005年入学的学生姓名(S_NAME)，SQL语句是(24)。A．SELECT S_NAME FROM R WHERE S_NO = '2005% 'B．SELECT S_NAME FROM R WHERE S_NO LIKE '2005% 'C．SELECT S_NAME FROM R WHERE S_NO = '2005%'D．SELECT S_NAME FROM R WHERE S_NO LIKE '2005%'
考题
某数据库表中有个一Name字段，查询Name为Mary和Lisa的记录的准则可以设置为（ ）。A.In（"Mary"，"Lisa"）B.Like"Mary"AndLike""Lisa"C.Like（"Mary"，"Lisa"）D."Mary"And"Lisa"
考题
某数据库表中有一个Name字段，查找Name为Mary和Lisa的记录的准则可以设置为( )。A．In("Mary","Lisa")B．Like"Mary"And Like"Lisa"C．Like("Mary","Lisa")D．MaryAnd"Lisa"
考题
要查询book表中所有书名以“电子商务”开头的书籍作者，可用(61)语句。A.SELECT author FROM booK WHERE book _name=‘电子商务*’B.SELECT author FROM booK WHERE book _name LIKE‘电子商务*’C.SELECT author FROM booK WHERE book_ name=‘电子商务%’D.SELECT author FROM booK WHERE book_name LIKE‘电子商务%’
考题
要查询st_info表中姓"王"且单名的学生情况，可用（）命令。A、SELECT * FROM st_info WHERE st_name LIKE ´王%´B、SELECT * FROM st_info WHERE st_name LIKE ´王_´C、SELECT * FROM st_info WHERE st_name=´王%´D、SELECT * FROM st_info WHERE st_name=´王__´
考题
数据库中有一张表名为Emp，包含有如下列：EmpNO（雇员编号，Varchar（20），Pk），Job（职位Varchar（10）），HirDate（雇佣日期，Date），Sal（月薪，Float）。要求查询全部雇员信息应该是哪些数据？（）A、Select * From EmpB、Select * From Emp Where EmpNO Like '%%'C、Select * From Emp Where Name = '%%'D、Select * From Emp Where Name Like '%%'
考题
如果要查询book表中所有书名以“数据库”开头的书籍价格，下列（）语句是正确的。A、SELECT price FROM book WHERE book_name＝“数据库*”B、SELECT price FROM book WHERE book_name LIKE“数据库*”C、SELECT price FROM book WHERE book_name＝“数据库%”D、SELECT price FROM book WHERE book_name LIKE“数据库%”
考题
An administrator would like to know the name of the workstation that is being repaired. Which ofthe following commands, without parameters, will provide this information?（）A、HostnameB、IpconfigC、NetstatD、Ping
考题
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（） A、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';B、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';C、SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "/";D、SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
考题
You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B、SELECT last_name FROM EMP WHERE last name ='*A%'C、SELECT last_name FROM EMP WHERE last name ='_A%';D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'
考题
下列哪些SQL语句可以查询出User表中name为张三的记录（）。A、SELECT * FROM User WHERE name = ’张三’B、SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1C、SELECT * FROM User WHERE name LIKE ’张三’D、SELECT * FROM User WHERE name LIKE ’%张三%’
考题
单选题The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）A
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA/_%' ESCAPE '/';B
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';C
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE /;D
SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
考题
多选题下列哪些SQL语句可以查询出User表中name为张三的记录（）。ASELECT * FROM User WHERE name = ’张三’BSELECT * FROM User WHERE name = ’张三’ LIMIT 0，1CSELECT * FROM User WHERE name LIKE ’张三’DSELECT * FROM User WHERE name LIKE ’%张三%’
考题
单选题要查询st_info表中姓"王"且单名的学生情况，可用（）命令。A
SELECT * FROM st_info WHERE st_name LIKE ´王%´B
SELECT * FROM st_info WHERE st_name LIKE ´王_´C
SELECT * FROM st_info WHERE st_name=´王%´D
SELECT * FROM st_info WHERE st_name=´王__´
考题
单选题You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）A
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';B
SELECT last_name FROM EMP WHERE last name ='*A%'C
SELECT last_name FROM EMP WHERE last name ='_A%';D
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
考题
单选题如果要查询book表中所有书名以“数据库”开头的书籍价格，下列（）语句是正确的。A
SELECT price FROM book WHERE book_name＝“数据库*”B
SELECT price FROM book WHERE book_name LIKE“数据库*”C
SELECT price FROM book WHERE book_name＝“数据库%”D
SELECT price FROM book WHERE book_name LIKE“数据库%”
考题
单选题在SQL中，下列涉及通配符的操作，匹配范围最大的是（）。A
name LIKE ´hgf_´B
name LIKE ´hgf%´C
name LIKE ´hgf_t%´D
name LIKE ´h%´
考题
查询student数据库中grade表中学生姓名st_name含有“国”的全部学生情况，可用什么命令？ (1.0分) [单选.]
A. select * from grade where st_name like ‘国’; B. select * from student where st_name like ‘国’; C. select * from grade where st_name= ‘国’; D. select * from grade where st_name like ‘%国%’;
热门标签
最新试卷