“图书”表中有字符型字段“图书名称”和“图书类型”,要求用SQL DELETE命令将图书表中书名中含有“计算
A. DELETE FROM图书FOR图书名称LIKE”%计算机%”AND图书类型=”小说”
B. DELETE FROM图书WHILE图书名称LIKE”计算机”AND图书类型=”小说”
C. DELETE FROM图书WHERE图书名称=”%计算机%”AND图书类型=”小说”
D. DELETE FROM图书WHERE图书名称LIKE”%计算机%”AND图书类型=”小说”
A. DELETE FROM图书FOR图书名称LIKE”%计算机%”AND图书类型=”小说”
B. DELETE FROM图书WHILE图书名称LIKE”计算机”AND图书类型=”小说”
C. DELETE FROM图书WHERE图书名称=”%计算机%”AND图书类型=”小说”
D. DELETE FROM图书WHERE图书名称LIKE”%计算机%”AND图书类型=”小说”
A.DELETE FROM图书FOR图书名称LIKE”%计算机%”AND图书类型=”小说”
B.DELETE FROM图书WHILE图书名称LIKE”计算机”AND图书类型=”小说”
C.DELETE FROM图书WHERE图书名称=”%计算机%”AND图书类型=”小说”
D.DELETE FROM图书WHERE图书名称LIKE”%计算机%”AND图书类型=”小说”
(25)当前打开的图书表中有字符型字段“图书号”,要求将图书号以字母A开头的图书记录全部打上删除标记,通常可以使用命令A)DELETE FOR图书号="A" B)DELETE WHILE图书号="A"C)DELETE FOR图书号="A*" D)DELETE FOR图书号LIKE "A%"
A.SELECT*FROM图书where出版日期Between#2010-01-01#and#2010-12-31#
B.SELECT*FROM图书where出版日期>=2010-01-01and出版日期2010-12-31#
C.SELECT*FROM图书where出版日期=2010
D.SELECT*FROM图书where出版日期Between2010-01-01and2010-12-31
A. DELETE FROM图书FOR图书号LIKE”A%”
B. DELETE FROM图书WHILE图书号LIKE”A%”
C. DELETE FROM图书WHERE图书号=”A*”
D. DELETE FROM图书WHERE图书号LIKE”A%”
A.DELETE FOR图书号="A"
B.DELETE WHILE图书号="A"
C.DELETE FOR图书号="A*"
D.DELETE FOR图书号LIKE"A%"
A.DELETE FROM 图书 FOR 图书号LIKE"A%"
B.DELETE FROM 图书 WHILE 图书号LIKE"A%"
C.DELETE FROM 图书 WHERE 图书号="A*"
D.DELETE FROM 图书 WHERE 图书号LIKE"A%"
A.DELETE FOR AT("A",分类号)=1
B.DELETE FOR AT分类号="A"
C.DELETE FOR SUBSTR(分类号,1,1)="A"
D.DELETE FOR"A"$分类号
A.DELETE FOR’D’$书号
B.DELETE FOR SUBSTR= ’D’
A.DELETE FOR"D"$书号
B.DELETE FOR SUBSTR(书号,1,1)="D"
C.DELETE FOR 书号=D。
D.DELETE FOR RIGHT(书号,1)= "D"
A.CREATE TABLE图书(图书编号VARCHAR(8),入库日期DATE,是否打折BIT NOT NULL)
B.CREATE TABLE图书(图书编号)CHAR(8)PRIMARY KEY,入库日期DATETIME,是否打折BIT NOT NULL)
C.CREATE TABLE图书(图书编号)VARCHAR(8)PRIMARY KEY,入库日期DATETIME,是否打折BIT IS NOT NULL)
D.CREATE TABLE图书(图书编号)CHAR(8),入库日期DATETIME,是否打折BIT IS NOT NULL)
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!