SQL with Python Quiz

What is the name of the new database used in the lesson?

• movies.db

• music.db

• entertainment.db

• media.db

Which tab in DB Browser is used to execute SQL commands?

• Execute SQL

• Edit Pragmas

• Browse Data

• Database Structure

What SQL clause is used to specify the table from which to retrieve data?

• WHERE

• ORDER BY

• FROM

• SELECT

Which SQL clause is used to filter records based on specific conditions?

• GROUP BY

• WHERE

• FROM

• SELECT

What is the purpose of the WHERE clause in SQL?

• To group records

• To sort the results

• To filter records based on conditions

• To specify the columns to retrieve

Which operator is used in SQL to match a pattern?

• LIKE

• IN

• BETWEEN

• =

What does the '%' wildcard represent in SQL?

• Zero or more characters

• A single character

• A numeric range

• An exact match

Which SQL query retrieves the title and genre of all movies released in 1985?

• SELECT title, genre FROM movies_80s WHERE release_date = 1985

• SELECT title, genre FROM movies_80s WHERE release_date = 1980

• SELECT title, genre FROM movies_80s WHERE release_date = 1990

• SELECT title, genre FROM movies_80s WHERE release_date = 1975

Which SQL query retrieves the title and distributor of movies with a rank greater than 5?

• SELECT title, distributor FROM movies_80s WHERE rank <= 5

• SELECT title, distributor FROM movies_80s WHERE rank > 5

• SELECT title, distributor FROM movies_80s WHERE rank = 5

• SELECT title, distributor FROM movies_80s WHERE rank < 5

Which SQL query retrieves the title and release date of movies with the genre 'Comedy'?

• SELECT title, release_date FROM movies_80s WHERE genre = 'Action'

• SELECT title, release_date FROM movies_80s WHERE genre = 'Drama'

• SELECT title, release_date FROM movies_80s WHERE genre = 'Horror'

• SELECT title, release_date FROM movies_80s WHERE genre = 'Comedy'