NEW
Font size
S
M
L
XL
WorksheetsSQL Queries
Total questions: 25
Worksheet time: 29mins
Name
Class
Date
1.
Write a code for the following: Return all romances that have an imdb_rating over 6.
a)
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;
b)
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;
c)
SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;
d)
SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;
2.
Write a code for the following: Return the names and imdb_ratings of all movies with ‘day’ in the name.
a)
SELECT * FROM movies WHERE name LIKE ‘day’;
b)
RETURN name, imdb_rating FROM movies WHERE name LIKE '%day%';
c)
SELECT name, imdb_rating FROM movies WHERE name LIKE '%day%';
d)
SELECT * FROM movies WHERE imdb_rating AND name LIKE ‘%day%’;
3.
A column in a database
a)
record
b)
row
c)
field
d)
data
4.
a)
ANSWER: SELECT id, name, year FROM movies WHERE year > 2010;
b)
ANSWER: SELECT id, name, year FROM movies WHERE year < 2010;
c)
ANSWER: SELECT * FROM movies WHERE year > 2010;
d)
ANSWER: SELECT id, name, year FROM movies WHERE YEAR > 2010;
5.
Return all dramas made after 2004.
a)
SELECT * FROM movies WHERE genre = 'drama';
b)
SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;
c)
SELECT * FROM movies WHERE genre = "drama' AND year < 2004;
d)
SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7
6.
Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.
a)
SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;
b)
SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;
c)
SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;
d)
SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;
7.
What is a special value in SQL that represents missing or unknown data?
a)
%
b)
?
c)
NULL
d)
*
8.
Return 2 movies with that include the word power.
a)
SELECT * FROM movies WHERE name = ‘%power%’ LIMIT 2;
b)
SELECT * FROM movies WHERE genre LIKE ‘%power%’ LIMIT 2;
c)
SELECT * FROM movies WHERE name LIKE ‘%power%’ LIMIT 2;
d)
SELECT * FROM games WHERE name LIKE ‘%power%’ LIMIT 2;
9.
Return 5 movies with an imdb rating of 7 or higher.
a)
SELECT * FROM movies WHERE imdb_rating = 7 limit 5;
b)
SELECT * FROM movies WHERE imdb-rating >= 7 LIMIT 5;
c)
SELECT * FROM movies WHERE imdb_rating <= 7 LIMIT 5;
d)
SELECT * FROM movies WHERE imdb_rating >= 7 LIMIT 5;
10.
Return 8 romances that were made before 1999.
a)
SELECT * FROM movies WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;
b)
SELECT * FROM movies WHERE genre = romance AND year > 1999 LIMIT 8;
c)
SELECT * FROM games WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;
d)
SELECT * FROM Movies WHERE genre = ‘romance’ AND year > 1999 LIMIT 8;
11.
a)
SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7 LIMIT 8; ORDER BY ASC LIMIT 8;
b)
SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7 LIMIT 8;
c)
SELECT * FROM movies WHERE imdb_rating >= 7 LIMIT 8;
d)
SELECT * FROM movies WHERE genre = 'horror' AND imdb_rating >= 7;
12.
Write the code for the following : Return all movies with the word love.
a)
SELECT * FROM movies WHERE name LIKE %love%;
b)
SELECT * FROM movies WHERE name LIKE ‘love’;
c)
SELECT * FROM movies WHERE name LIKE %love;
d)
SELECT * FROM movies WHERE name LIKE ‘%love%’;
13.
Which of the following code is written correctly?
a)
SELECT * FROM movies WHERE imdb_rating is 1 AND ORDER by desc;
b)
SELECT * FROM movies WHERE genre = ‘comedy’ AND ORDER BY ASC LIMIT 1:
c)
SELECT * FROM movies WHERE genre = ‘horror’;
d)
SELECT * FROM movies genre is horror, and rating is 2;
14.
Write the code for the following: Return all movies made before 2011 and order by the imdb rating from highest to lowest.
a)
RETURN * FROM movies WHERE year < 2011 AND imdb_rating ASC;
b)
SELECT * FROM movies WHERE year > 2011 ORDER BY imdb_rating DESC;
c)
SELECT * FROM movies WHERE year < 2011 ORDER BY imdb_rating DESC;
d)
SELECT * FROM movies WHERE year = 2011 ORDER BY imdb_rating ASC;
15.
What is wrong with the following code: SELECT * FROM movies WHERE genre = comedy AND year < 2016 ORDER BY year DESC;
a)
Comedy should have single quotes around it
b)
AND should be lower case
c)
movies should be capitalized
d)
No changes should be made
16.
a)
SELECT name, year FROM movies WHERE name LIKE '%B' ORDER BY year DESC LIMIT 6;
b)
SELECT * FROM movies WHERE name LIKE 'B%' ORDER BY year DESC LIMIT 6;
c)
SELECT name, year FROM movies WHERE name LIKE 'B%' ORDER BY year ASC LIMIT 6;
d)
SELECT name, year FROM movies WHERE name LIKE 'B%' ORDER BY year DESC LIMIT 6;
17.
Return 5 movies that have an imdb rating greater than 4 and are comedies.
a)
SELECT * FROM movies WHERE imdb_rating > 4 AND genre = ‘comedy’ LIMIT 5;
b)
SELECT ALL FROM movies WHERE imdb_rating < 4 AND genre = ‘comedy’ LIMIT 5;
c)
SELECT * FROM movies WHERE imdb rating > 4 AND genre = comedy LIMIT 5;
d)
SELECT ALL FROM movies WHERE imdb_rating > 4 AND genre = ‘comedy’;
18.
What is wrong with the following code: SELECT * FROM movies WHERE genre = ‘romance’ AND imdb rating > 8;
a)
The asterisk doesn’t need to be there
b)
The equal sign needs to go before genre
c)
There needs to be an underscore in between imdb and rating
d)
The single quotes don’t need to be there
19.
Write the code for the following: Return all movies containing the word iron.
a)
SELECT * FROM i am a beast 1,2,3 WHERE name LIKE ‘%iron%’;
b)
SELECT * FROM movies WHERE name LIKE ‘%iron%’
c)
SELECT * FROM movies WHERE name LIKE ‘%iron%’;
d)
SELECT FROM movies WHERE name LIKE ‘%iron%’;
20.
What does * mean when writing code?
a)
Select all columns
b)
Select all rows
c)
Select all genres
d)
Select jaskfjfjfjsfjiosjisjfjsfjsfjkjsk
21.
Which of these groups are in the six common operators?
a)
#=, ^=, $=
b)
=, !=, >=
c)
>^, <>, =+
d)
<+>, >=<, (<)
22.
What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;
a)
Missing an AND
b)
Table name
c)
Capitalize action
d)
None of these
23.
Write the code for the following: Search the unique genres located in movies table.
a)
SELECT DISTINCT genre from movies;
b)
SELECT DISTINCT genres FROM movies;
c)
SELECT DISTINCT genre FROM movies;
d)
none of these
24.
a)
SELECT genre, year FROM movies WHERE genre = 'action' ORDER BY year ASC LIMIT 11;
b)
SELECT genre, year FROM movies WHERE genre = action ORDER BY year DESC LIMIT 11;
c)
none of these
d)
SELECT genre, year FROM movies WHERE genre = 'action' ORDER BY year DESC LIMIT 11;
25.
a)
SELECT * FROM movies WHERE genre = 'romance' AND imdb_rating > 7.5 ORDER BY year DESC LIMIT 4;
b)
SELECT * FROM movies WHERE genre = 'romance' AND imdb_rating > 7.5 ORDER BY year ASC LIMIT 4;
c)
SELECT * FROM movies WHERE genre = romance AND imdb_rating > 7.5 ORDER BY year DESC LIMIT 4;
d)
SELECT * FROM movies WHERE genre = 'romance' AND imdb_rating < 7.5 ORDER BY year DESC LIMIT 4;
Reset
