如下几个表所示学生、课程、必修课和选课关系,用SQL语言实现下列操作。将“选课”表中的1002号课的所有成绩提高10分,正确的SQL语句是_____。
A.UPDATE 选课SET 成绩=成绩+10WHERE 课号=‘1002’;
B.UPDATE 选课SET 成绩=成绩+10WHERE 课号=1002;
C.SET 选课UPDATE 成绩=成绩+10WHERE 课号=‘1002’;
D.UPDATE 选课SET 成绩+10WHERE 课号=‘1002’;
A.UPDATE 选课SET 成绩=成绩+10WHERE 课号=‘1002’;
B.UPDATE 选课SET 成绩=成绩+10WHERE 课号=1002;
C.SET 选课UPDATE 成绩=成绩+10WHERE 课号=‘1002’;
D.UPDATE 选课SET 成绩+10WHERE 课号=‘1002’;
A、UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=‘1002’
B、UPDATE 选课 SET 成绩+10 WHERE 课号=‘1002’
C、SET 选课 UPDATE 成绩=成绩+10 WHERE 课号=‘1002’
D、UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=1002
A.SELECT 学号 RORM SC WHERE 课程号="C1"AND 课程号="C5"
B.SELECT 学号 RORM SC WHERE 课程号="C1"AND 课程号=(SELECT 课程号 FROM SC WHERE 课程号="C5")
C.SELECT 学号 RORM SC WHERE 课程号="C1"AND 学号=(SELECT 学号 FROM SC WHERE 课程号="C5")
D.SELECT 学号 RORM SC WHERE 课程号="C1"AND 学号 IN(SELECT 学号 FROM SC WHERE课程号="C5")
S (SNO, SNAME, SAGE, SDEP);
C (CNO, CNAME);
SC (SNO, CNO, GRADE)。
其中SNO是学生号,SNAME是学生姓名,SAGE是年龄, SDEP是学生所在系,CNO是课程号,CNAME是课程名称。
“查询计算机科学系年龄介于15岁至19岁之间的学生”,其SQL语句为()。
A.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE BETWEEN 15 AND 19;
B.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE<= 19 AND SAGE >= 15;
C.SELECT * FROM S WHERE SDEP = ‘CS’ OR SAGE BETWEEN 15 AND 19;
D.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE<= 19 OR SAGE >= 15;
A、DELETE FROM 课程 WHERE 课号=‘2003’;
B、DELETE FROM 课程 WHERE 课号=2003;
C、DELETE FROM 课程 WHERE ‘2003’;
D、DELETE FROM 课程.课号=‘2003’;
A、
B、
C、
D、其它选项都不正确
A、
B、
C、
D、
A、Update Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname=‘计算机’);
B、Update Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname =‘计算机’);
C、Update Salary = Salary * 1.1 Where D# in (Select D# From Dept Where Dname = 计算机);
D、Update TABLE Teacher Set Salary = Salary * 1.1 Where D# in ( Select D# From Dept Where Dname = ‘计算机’);
A、SELECT Title_Id,Title FROM Titles WHERE price>ALL(SELECT price FROM Titles WHERE Pub_id=‘0736’)
B、SELECT Title_Id,Title FROM Titles WHERE price>ALL(SELECT price FROM Titles) AND Pub_id=‘0736’
C、SELECT Title_Id,Title FROM Titles WHERE price>ANY(SELECT price FROM Titles WHERE Pub_id=‘0736’)
D、SELECT Title_Id,Title FROM Titles WHERE price>ANY(SELECT price FROM Titles) AND Pub_id=‘0736’
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!