如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为—— A: SELECT title FR

1.如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为—— 选项： A、SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’; B、SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’; C、SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’; D、SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;

2.如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为选项： A:SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’;; B:SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’;; C:SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’;; D:SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;

3.如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为——选项： A:SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’;; B:SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’;; C:SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’;; D:SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;

4.如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为—— 选项： A、SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’; B、SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’; C、SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’; D、SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;

5.如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为‍ A: SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’; B: SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’; C: SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’; D: SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;

6.已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期。基于该数据库完成以下SQL题目。如果要找出上映时间在1999年后(包括1999年)并且是 Cameron的电影的标题，SQL语句为（）选项： A:SELECT title FROM Movie WHERE year >= ‘1999’ and director == ‘Cameron’;; B: SELECT title FROM Movie WHERE year >= ‘1999’ and director = ‘Cameron’;; C:SELECT title FROM Movie WHERE year > ‘1999’ and director == ‘Cameron’;; D:SELECT title FROM Movie WHERE year > ‘1999’ and director = ‘Cameron’;

7.SQL语句SELECT * FROM Movie等价于下列哪一个语句?A．SELECT mID ，year，director FROM MovieB．SELECT mID ，title，director FROM MovieC．SELECT mID ，title FROM MovieD．SELECT mID ，title，year，director FROM Movie

8.下列SQL语句哪一个是查询出所有电影的导演名字和上映年份() 选项：A、SELECT director,year FROM Movie B、SELECT title,director FROM Movie C、SELECT director,mID FROM Movie D、SELECT mID,title FROM Movie

9.要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为——选项： A:SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC;; B:SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC;; C:SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC;; D:SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;

10.要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为‍ 选项： A、SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC; B、SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC; C、SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC; D、SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;

11.要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为—— 选项： A、SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC; B、SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC; C、SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC; D、SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;

12.要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为选项： A:SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC;; B:SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC;; C:SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC;; D:SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;

13.要查出所有在1978，1997，2008年上映的电影的标题并以电影的编号降序输出，SQL语句为——A．SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID ASC;B．SELECT title FROM Movie WHERE year = ‘1978’ OR year = ‘1997’ OR year = ‘2008’ ORDER BY mID ASC;C．SELECT title FROM Movie WHERE year IN (‘1978’, ‘1997’, ‘2008’) ORDER BY mID DESC;D．SELECT title FROM Movie WHERE year = ‘1978’ AND year = ‘1997’ AND year = ‘2008’ ORDER BY mID DESC;

14.‌要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为‌ 选项： A、SELECT * FROM Movie WHERE director LIKE ‘_a_’; B、SELECT * FROM Movie WHERE director LIKE ‘%a%’; C、SELECT * FROM Movie WHERE director LIKE ‘%a_’; D、SELECT * FROM Movie WHERE director LIKE ‘_a%’;

15.要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为——选项： A:SELECT * FROM Movie WHERE director LIKE ‘_a_’;; B:SELECT * FROM Movie WHERE director LIKE ‘%a%’;; C:SELECT * FROM Movie WHERE director LIKE ‘%a_’;; D:SELECT * FROM Movie WHERE director LIKE ‘_a%’;

16.要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为（ )选项： A: SELECT * FROM Movie WHERE director LIKE ‘_a_’;; B:SELECT * FROM Movie WHERE director LIKE ‘%a%’;; C:SELECT * FROM Movie WHERE director LIKE ‘%a_’;; D: SELECT * FROM Movie WHERE director LIKE ‘_a%’;

17.要找出所有名字第二个字母为“a”的导演的电影信息，SQL语句为——A.SELECT * FROM Movie WHERE director LIKE ‘_a_’;B.SELECT * FROM Movie WHERE director LIKE ‘%a%’;C.SELECT * FROM Movie WHERE director LIKE ‘%a_’;D.SELECT * FROM Movie WHERE director LIKE ‘_a%’;

18.下列SQL语句哪一个是查询出所有电影的导演名字和上映年份——A．SELECT year，director FROM MovieB．SELECT mID，title FROM MovieC．SELECT director，year FROM MovieD．SELECT director，mID FROM Movie

19.已知影片评论数据库包括如下表结构：Movie(mID,title,year,director)表，属性包括影片编号，影片名，发行年份以及导演。viewer(rID,name)者表，属性包括评论者编号，评论者姓名。ting(rID,mID,stars,ratingDate)表，属性包括评论者编号，影片编号，评分（1-5），评论日期。该数据库完成以下选择题。 SQL语句SELECT*FROM Movie等价于下列哪一个语句（）选项： A、SELECT mID，year，director FROM Movie B、SELECT mID，title FROM Movie C、SELECT mID，title，year，director FROM Movie D、SELECT mID，title，director FROM Movie

20.选择正确选项完成以下 MySQL 语句：SELECT actor FROM movie WHERE movieId in （）。选项： A:SELECT id FROM movie group by id WHERE director=Tom B:SELECT id FROM movie WHERE director=Tom C:WHERE name=Tom group by id D:FROM movie WHERE director=Tom

21.已知影片评论数据库包括如下表结构：Movie ( mID, title, year, director )影片表，属性包括影片编号，影片名，发行年份以及导演。Reviewer ( rID, name )评论者表，属性包括评论者编号，评论者姓名。Rating ( rID, mID, stars, ratingDate )评论表，属性包括评论者编号，影片编号，评分（1-5），评论日期。基于该数据库完成以下SQL题目。SQL语句SELECT * FROM Movie等价于下列哪一个语句（）选项： A:SELECT mID， year，director FROM Movie; B:SELECT mID，title， director FROM Movie; C: SELECT mID，title FROM Movie; D: SELECT mID，title，year，director FROM Movie