Data analysis

In a table of student records, What does this query return?

SELECT MAX(birthdate) FROM student_info;

• Youngest

• Oldest

• Middle

• None of these

Which of these birth years is the youngest?

• 1994

• 1949

• 1989

• 1990

Select the words that can be used interchangeably for relational databases.

• record

• row

• column

• field value

• key

Select the words that can be used interchangeably for relational databases.

• field

• row

• column

• field value

• key

Which of these birth years is the oldest?

• 1994

• 1949

• 1989

• 1990

In a table of student records, What does this query return?

SELECT MIN(birthdate) FROM student_info;

• Youngest

• Oldest

• Middle

• None of these

Categorize these fields by whether they'd serve as a good primary key in a database of police suspects.

Groups:

(a) Good Choice

,

(b) Poor Choice

• Address

• Blood Type

• SSN (social security #)

• Driver's License/State/City ID #

• Phone #

• First, Middle, and Last Names (together)

The sun is a giant ball of fire.

• True

• Partly true

• False

Answer explanation

Watch the SciShow episode "Sound DOES Travel in Space (and 10 Other Space Things You Got Wrong)" on YouTube.