SQL Injection

Which statement is used to extract data from a database?

• Extract

• Get

• Open

• Select

If you were wanting to filter data, which clause would you use?

• Where

• Order by

• From

• Select

Using which word allows you to specify that more than one condition must be met in a query?

• Also

• And

• Or

• Where

What would the SQL query pictured do?

• Find all the men

• Find all of the female writers

• Find all of Elgar's friends

• Find all the male writers

• Find all the fish

With SQL, how do you select all the columns from a table named "Persons"?

•  SELECT [all] FROM Persons
•  SELECT *.Persons
•  SELECT * FROM Persons
•  SELECT Persons

Write a code for the following: Return all romances that have an imdb_rating over 6.

• SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating > 6;
• SELECT * FROM movies WHERE genre = ‘romance’ AND imdb_rating < 6;
• SELECT imdb_rating, name FROM movie WHERE genre = ‘romance’ AND imdb_rating > 6;
• SELECT * FROM movies WHERE genre = romance and imdb_rating < 6;

Return all dramas made after 2004.

• SELECT * FROM movies WHERE genre = 'drama';
• SELECT * FROM movies WHERE genre = 'drama' AND year > 2004;
• SELECT * FROM movies WHERE genre = "drama' AND year < 2004;
• SELECT * FROM movies WHERE imdb_rating = 7 AND LIMIT = 7

Which character returns all the data found in a table?

• %

• #

• *

• /

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

What is the correct order of clauses in a SQL statement?

• SELECT, FROM, ORDER BY, WHERE

• SELECT, FROM, WHERE, ORDER BY

• SELECT, WHERE, FROM, ORDER BY

• WHERE, FROM, SELECT, ORDER BY