网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

删除表Teacher中编号为070041的记录,应为()

  • A、DELETE FROM Teacher WHERE编号="070041"
  • B、DELETE FROM Teacher 编号="070041"
  • C、DELETE编号="070041"FROMTeacher
  • D、DELETE FROM Teacher WHERE编号IS"070041"

参考答案

更多 “删除表Teacher中编号为070041的记录,应为()A、DELETE FROM Teacher WHERE编号="070041"B、DELETE FROM Teacher 编号="070041"C、DELETE编号="070041"FROMTeacherD、DELETE FROM Teacher WHERE编号IS"070041"” 相关考题
考题 ( 28 )假设 “ 图书 ” 表中有 C 型字段 “ 图书编号 ” ,要求将图书编号以字母 A 开头的图书记录 全部打上删除标记,可以使用 SQL 命令A ) DELETE FROM 图书 FOR 图书编号 =''A"B ) DELETE FROM 图书 WHERE 图书编号 = " A% "C ) DELETE FROM 图书 FOR 图书编号 ="A * "D ) DELETE FROM 图书 WHERE 图书编号 LIKE "A%"

考题 从订单表中删除客户号为"1001”的订单记录,正确的SQL语句是A)DROP FROM订单WHERE客户号="1001"B)DROP FROM订单FOR客户号="1001"C)DELETE FROM订单WHERE客户号="1001"D)DELETE FROM订单FOR客户号="1001"

考题 25) “ 图书 ” 表中有字符型字段 “ 图书号 ” 。要求用 SQL DELETE 命令将图书号以字母 A 开头的图书记录全部打上删除标记,正确的命令是A)DELETE FROM 图书 FOR 图书号 LIKE " A % "B)DELETE FROM 图书 WHILE 图书号 LIKE " A % "C)DELETE FROM 图书 WHERE 图书号 = " A* "D)DELETE FROM 图书 WHERE 图书号 LIKE " A% "

考题 下列SELECT语句语法正确的是( )。A)SELECT木FROM‘teacher' WHERE性别=‘男’B)SELECT宰FROM‘teacher’WHERE性别=男C)SELECT木FROM teacher WHERE性别=男D)SELECT木FROM teacher WHERE性别=‘男’

考题 以下删除记录正确的( )A.delete from emp where name='dony';B.Delete * from emp where name='dony';C.Drop from emp where name='dony';D.Drop * from emp where name='dony';

考题 从student表删除年龄大于30的记录的正确SQL命令是( )。A.DELETE FOR年龄30B.DELETE FROM student WHERE年龄30C.DELETE student FOR年龄30D.DELETE student WHERE年龄30

考题 删除学号为“20091001”且课程号为“C1”的选课记录,正确命令是( )。A.DELETE FROM score WHERE课程号="C1"AND学号="20091001"B.DELETE FROM score WHERE课程号=”C1”OR学号="20091001"C.DELETE score WHERE课程号="C1"AND学号="20091001"D.DELETE score课程号="C1"OR学号="20091001"

考题 从订单表中删除客户号为“1001”的订单记录,正确的SQL语句是A.DROP FROM 订单 WHERE客户号=“1001”B.DROP FROM 订单 FOR 客户号= “1001”C.DELETE FROM 订单 WHERE 客户号=“1001”D.DELETE FROM 订单 FOR 客户号=“1001”

考题 假设“产品”表中有C型字段“产地”,要求将产地以“北京”开头的产品记录全部打上删除标记,正确的SQL命令是( )。A. DELETE FROM产品FOR产地=”北京”B. DELETE FROM产品WHERE产地=”北京%”C. DELETE FROM产品FOR产地=”北京*”D. DELETE FROM产品WHERE产地LIKE”北京%”

考题 "图书"表中有字符型字段“图书号”。要求用SQL DELETE命令将图书号以字母A开头的图书记录全部打上删除标记,正确的命令是( )。A. DELETE FROM图书FOR图书号LIKE”A%”B. DELETE FROM图书WHILE图书号LIKE”A%”C. DELETE FROM图书WHERE图书号=”A%”D. DELETE FROM图书WHERE图书号LIKE”A%”

考题 设有学生表:STUD(学号,姓名,性别,年龄,专业),将学号为“20030019”的学生从该表中删除掉的语句是______。A.DELETE STUD WHERE学号="20030019"B.DELETE FROM STUD WHERE学号="20030019"C.DELETE TABLE STUD WHERE学号="20030019"D.DELETE FROM WHERE 学号="20030019"

考题 删除学号为“20091001”且课程号为“C1”的选课记录,正确命令是A.DELETE FROM score WHERE课程号=‘C1’AND学号=‘2009100l’B.DELETE FROM score WHERE课程号=‘C1’OR学号‘20091001’C.DELETE FORM. score WHERE课程号‘C1’AND学号=‘20091001’D.DELETE score WHERE课程号=‘C1’AND学号‘20091()0l’

考题 使用SQL语句将表s中字段price的值大于30的记录删除,正确的命令是( )。A.DELETE FROM S FOR price30B.DELETE FROM sWHERE price30C.DELETE S FOR pricC30D.DELETE S WHERE pricC30

考题 使用SQL语句将表S中字段price的值大于30的记录删除,正确的命令是A.DELETE FROM s FOR price30B.DELETE FROM s WHERE price30C.DELETE s FOR price30D.DELETE s WHERE price30

考题 设教师表的表结构为(教师编号,姓名,职称,出生日期),删除1950年以前出生的教师信息,正确的SQL语句是( )。A.DELETE FROM教师表WHERE出生日期{^1950-1-1}B.DELETE FROM教师表WHERE出生日期ˋ1950-1-1ˊC.DELETE教师表WHERE出生日期{^1950-1-1}D.DELETE教师表WHERE出生日期ˋ1950-1-1ˊ

考题 下列执行数据的删除语句在运行时不会产生错误信息的是( )。 A delete * from A where B=‘6’B delete * from A where B=‘6’C delete A where B=6D delete A set where B=‘6’

考题 设有学生表:STUD(学号,姓名,性别,年龄,专业),把学号为“20030019”的学生从该表中删除掉的语句是______。A.DELETE STUD WHERE 学号=“20030019”B.DELETE FROM STUDWHERE学号=“20030019”C.DELETE TABLE STUD WHERE学号=“20030019”D.DELETE FROM WHERE 学号=“20030019”

考题 删除“持有数”表中所有外币名称为“法郎”的记录,下列SQL语句正确的是( )。A)DELETE FROM持有数;WHERE持有数.外币代码=外汇名.外币代码;AND外币名称=“法郎”B)DELETE FROM持有数,外汇名;WHERE持有数.外币代码=外汇名.外币代码;AND外币名称=“法郎”C)DELETE FROM持有数WHERE外币代码IN;(SELECT外币代码FROM外汇名WHERE外币名称=“法郎”)D)DELETE FROM持有数WHERE外币代码IN;SELECT外币代码FROM外汇名WHERE外币名称=“法郎”

考题 在Access中,删除"订单"表中所有记录,应运行的SQL命令是()A、delete*from"订单"B、delete*from订单C、delete*from"订单ID"D、delete*from订单ID

考题 在Access中,从"订单"数据表中删除订单ID为"A10257"的记录,应运行的SQL命令是()A、delete*from订单where订单ID="A10257"B、delete*from订单where订单ID=A10257C、delete*from订单ID where订单="A10257"D、delete*from订单ID where订单=A10257

考题 删除“职工”表中没有写入工资的记录,应该使用的命令是()。A、DELETE FROM职工WHERE工资=NULLB、DELETE FROM职工WHERE工资=!NULLC、DELETE FROM职工WHERE工资IS NOT NULL

考题 可以删除学生表中学号为‘s2008005’的是()。A、"begin tran delete from学生表where学号=‘s2008005’ rollback"B、"begin tran delete from学生表where学号=‘s2008005’ commit"C、"begin tran delete where学号=‘s2008005’ from 学生表 rollback"D、"begin tran delete where学号=‘s2008005’ commit"

考题 假设某数据表中有一个"生日"字段,删除80年出生的学生记录的语句是()A、DELETE FROM Student WHERE生日Between #80-01-01#And#80-12-31#B、DELETE FROM Student WHERE生日Between("80-01-01"And"80-12-31")C、DELETE FROM Student WHERE生日Between("80.01.01"And"80.12.31")D、DELETE FROM Student WHERE生日Between #80.01.01#And#80.12.31#

考题 根据关系模型Teacher(编号,职称)下列SQL语句正确的是()A、INSERT INTO Teacher(编号,职称)VALUES("070041","助教")B、INSERT INTO Teacher("070041","助教")VALUES(编号,职称)C、INSERT INTO VALUES(编号,职称)Teacher("070041","助教")D、INSERT INTO VALUES("070041","助教")Teacher(编号,职称

考题 单选题根据关系模型Teacher(编号,职称)下列SQL语句正确的是()A INSERT INTO Teacher(编号,职称)VALUES(070041,助教)B INSERT INTO Teacher(070041,助教)VALUES(编号,职称)C INSERT INTO VALUES(编号,职称)Teacher(070041,助教)D INSERT INTO VALUES(070041,助教)Teacher(编号,职称

考题 单选题删除表Teacher中编号为070041的记录,应为()A DELETE FROM Teacher WHERE编号=070041B DELETE FROM Teacher 编号=070041C DELETE编号=070041FROMTeacherD DELETE FROM Teacher WHERE编号IS070041

考题 单选题可以删除学生表中学号为‘s2008005’的是()。A begin tran delete from学生表where学号=‘s2008005’ rollbackB begin tran delete from学生表where学号=‘s2008005’ commitC begin tran delete where学号=‘s2008005’ from 学生表 rollbackD begin tran delete where学号=‘s2008005’ commit