DataBase DOL #3

True or False: A record refers to an entire row of related data in a dataset.

• TRUE

• FALSE

Which of the following is a dataset?

• A single record of one book

• A single record of one book

• A search engine

• A table listing book titles, authors, and publication years

Which of the following are examples of logical operators? (Select all that apply)

• AND

• OR

• NOT

• FIELD

• TABLE

Match the following terms with their definitions:

• Record

• Excludes results that meet certain conditions.

• Fields

• A collection of related categories.

• NOT

• A single piece of data in a database.

• OR

• Includes results meeting all conditions.

• AND

• Includes results meeting at least one condition.

Below is a table of items in a store. Use the information to select *everything* that is blue and the cost

less than $60.

SELECT _____ FROM ____WHERE Color = "_____" AND Price ____60;

(a)