MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
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
Explanation: 
There is 1 question to complete.