请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
-
1.若要查询Rating中评分最高的电影，返回电影名title和其对应的最高评分，则下列空白处需要填入——。SELECT title, stars FROM Movie,RatingWHERE Movie.mID=Rating.mID AND (SELECT stars FROM Rating)选项： A:Stars>ALL; B:NOT stars>ALL; C:Stars
-
2.若要查询Rating中评分最高的电影，返回电影名title和其对应的最高评分，则下列空白处需要填入（ ）。SELECT title, stars FROM Movie,RatingWHERE Movie.mID=Rating.mID AND (SELECT stars FROM Rating)选项： A:Stars>ALL; B:NOT stars>ALL; C:Stars
- 3.若要查询Rating中评分最高的电影，返回电影名title和其对应的最高评分，则下列空白处需要填入（) SELECT title, stars FROM Movie,Rating WHERE Movie.mID=Rating.mID AND （SELECT stars FROM Rating) 选项：A．Stars＞ALLB．NOT stars＞ALLC．Stars＜ANYD．NOT stars＜ANY
- 4.要找出对同一部电影评论次数在3次及以上的评论者姓名，下列语句不能实现该功能的是 选项： A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B、select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C、select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D、select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
- 5.要找出对同一部电影评论次数在3次及以上的评论者姓名，下列语句不能实现该功能的是—— 选项： A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B、select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C、select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D、select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
- 6.要找出对同一部电影评论次数在3次及以上的评论者姓名，下列语句不能实现该功能的是—— A: select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B: select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C: select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D: select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
- 7.要找出对同一部电影评论次数在3次及以上的评论者姓名，下列语句不能实现该功能的是——选项： A:select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3; B:select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3; C:select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3; D:select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
- 8.若要查询评论了所有电影的评论者name,则下列空白处需要依次填入（ ）。SELECT name FROM Reviewer WHERE rID (SELECT * FROM Movie WHERE mID (SELECT mID FROM RatingWHERE Reviewer.rID=Rating.rID and Movie.mID=Rating.mID))选项： A: NOT IN, NOT IN; B: NOT EXISTS, NOT EXISTS; C:NOT IN, NOT EXISTS; D:NOT EXISTS, NOT IN
- 9.若要查询评论了所有电影的评论者name,则下列空白处需要依次填入——。SELECT name FROM Reviewer WHERE rID (SELECT * FROM Movie WHERE mID (SELECT mID FROM RatingWHERE Reviewer.rID=Rating.rID and Movie.mID=Rating.mID))选项： A:NOT IN, NOT IN; B:NOT EXISTS, NOT EXISTS; C:NOT IN, NOT EXISTS; D:NOT EXISTS, NOT IN
- 10.若要查询评论了所有电影的评论者name,则下列空白处需要依次填入——。SELECT name FROM Reviewer WHERE rID (SELECT * FROM Movie WHERE mID (SELECT mID FROM RatingWHERE Reviewer.rID=Rating.rID and Movie.mID=Rating.mID)) A: NOT IN, NOT IN B: NOT EXISTS, NOT EXISTS C: NOT IN, NOT EXISTS D: NOT EXISTS, NOT IN
- 11.已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期。基于该数据库完成以下SQL题目。要找出对同一部电影评论次数在3次及以上的评论者姓名，下列语句不能实现该功能的是（ ）选项： A:select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3; B:select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3; C:select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3; D:select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
- 12.要找出对同一部电影评论次数在3次及以上的评论者姓名，下列语句不能实现该功能的是—— 选项： A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid having count(stars)>=3 B、select name from reviewer A where (select count(stars) from rating B where A.rid=B.rid group by rid)>=3 C、select name from reviewer where (select count(stars) from rating where reviewer.rid=rating.rid)>=3 D、select name from review,rating where reviewer.rid=rating.rid and count(stars)>=3 group by reviewer.rid
- 13.下面SQL语句中不正确的一项是—— 选项： A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid B、select name from reviewer,rating where reviewer.rid=rating.rid having count(stars)>=3 C、select name from reviewer,rating group by reviewer.rid having count(stars)>=3 D、select name from reviewer,rating group by reviewer.rid where count(stars)>=3
- 14.下面SQL语句中不正确的一项是—— 选项： A、select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid B、select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3 C、select name from reviewer,rating group by reviewer.rid having count(stars)>=3 D、select name from reviewer,rating group by reviewer.rid where count(stars)>=3
- 15.下面SQL语句中不正确的一项是——A．select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.ridB．select name from reviewer,rating group by reviewer.rid where count(stars)>=3C．select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3D．select name from reviewer,rating group by reviewer.rid having count(stars)>=3
- 16.下面SQL语句中不正确的一项是—— A: select name from reviewer,rating where reviewer.rid=rating.rid group by reviewer.rid B: select name from reviewer,rating where reviewer.rid=rating.rid and count(stars)>=3 C: select name from reviewer,rating group by reviewer.rid having count(stars)>=3 D: select name from reviewer,rating group by reviewer.rid where count(stars)>=3
- 17.已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演，其中mID是主键。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名，其中rID是主键。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期，其中(rID, mID, ratingDate)是主键。若要查询评论了所有电影的评论者name,则下列空白处需要依次填入（ ）。SELECT name FROM Reviewer WHERE rID (SELECT * FROM Movie WHERE mID (SELECT mID FROM Rating WHERE Reviewer.rID=Rating.rID and Movie.mID=Rating.mID))选项： A: NOT IN, NOT IN; B: NOT EXISTS, NOT EXISTS; C:NOT IN, NOT EXISTS; D:NOT EXISTS, NOT IN
- 18.下列语句为查询给导演” Spielberg”执导电影评过分的reviewer信息，下列空白处应该填写（ ）SELECT * from Reviewer where rID ____ (SELECT rID from Rating,MovieWHERE Movie.mID = Rating.mIDAND Movie.director = “Spielberg” ) A: EXISTS B: NOT EXISTS C: ANY D: IN
- 19.若电影评分5星为100分，4星为80分，3星为60分，2星为40分, 1星为20分。补全下面SQL语句达到将电影的编号和星级查询并转化为百分制显示出来的效果——SELECT________________FROM Rating选项： A:starts+20; B:stars*20; C:mID，stars*20; D:mID，stars+20
- 20.已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演，其中mID是主键。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名，其中rID是主键。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期，其中(rID, mID, ratingDate)是主键。下列语句为查询给导演” Spielberg”执导电影评过分的reviewer信息，下列空白处应该填写（ ）SELECT * from Reviewer where rID ____ (SELECT rID from Rating,Movie WHERE Movie.mID = Rating.mIDAND Movie.director = “Spielberg” )选项： A:EXISTS ; B:NOT EXISTS ; C:ANY ; D: IN
