LO9_Lesson 4

Which Symbol means "All"

• *

• &

• %

• !

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

A database can be stored on a computer or paper-based (manual)

• True

• False

In a database for an online shopping company, all the information about a single customer would be stored as a ...

• Field

• Record

• Relationship

• Table

In a database for an online shopping company, all the customer information would be stored as a ...

• Field

• Record

• Relationship

• Table

In a database for an online shopping company, do you think that an email address can be used as a primary key in the customer table?

• True

• False

In the table shown, which field is likely to be the primary key?

(a)  

SELECT First_Name

FROM Employee

WHERE Title = "President"

Would return what?

(a)  

SELECT First_Name

FROM Employee

WHERE Title = "Programmer" AND Gender = "F"

Would return what?

• Yolanda

• Yolanda and Jennifer

• Jennifer

Which clause is used to sort the result of SELECT statement?

• SORT BY

• ORDER BY

• ARRANGE BY

• None of the above