Database Structure and Core Vocabulary: 10 practice questions

Question 1 of 10

Which query returns only the name column of the artists table?

1. ASELECT name, artist_id FROM artists;
2. BSELECT artists FROM name;
3. CFROM artists SELECT name;
4. DSELECT name FROM artists;

Question 2 of 10

The composer box of Balls to the Wall is empty. What does SELECT name, composer FROM tracks; show for that song?

1. AAn error, because one box has no value
2. BThe song, with the number zero
3. CNothing, because that song is left out
4. DThe song, with a null box beside it

Question 3 of 10

A query on albums asks for artist_id first and title second. What does the result show?

1. AThe titles first, because they are text
2. BThe titles first, as the table stores them
3. CThe id numbers, then the titles
4. DOne column only, since one has to come first

Question 4 of 10

You want to know how long each song lasts. Which table do you read?

1. AAny of the three tables
2. BThe albums table
3. CThe artists table
4. DThe tracks table

Question 5 of 10

Running SELECT name, milliseconds FROM artists; gives an error. What is the fix?

1. AAdd a data type to the column
2. BAsk for the two columns in the other order
3. CWrite the name column twice
4. DRead the tracks table instead

Question 6 of 10

One day a second artist is stored with the same text in name as an older one. Why can the store still tell them apart?

1. AThe store refuses the second artist
2. BTheir key values are different
3. CThe two rows are told apart by position
4. DThe second artist goes in another table

Question 7 of 10

The albums row with album_id 5 stores artist_id 3. How do you find out who made that album?

1. ARead the third row shown in the artists table
2. BCount the rows of artists as far as number 3
3. CRead the artists row whose artist_id is 3
4. DRead the albums row whose album_id is 3

Question 8 of 10

The albums table has six rows and three columns. What does SELECT title FROM albums; return?

1. AOne row with six columns
2. BOne row holding the number six
3. CSix rows with three columns
4. DSix rows with one column

Question 9 of 10

The artists table stores artist 4 as Alanis Morissette. What does SELECT name FROM artists; return for that row?

1. ABoth the number 4 and the text
2. BNothing, because the id is not named
3. CAlanis Morissette, with no id number
4. DThe number 4, with no text

Question 10 of 10

Row 5 of albums is album_id 5, title Big Ones, artist_id 3. Which box of that row holds text?

1. AAll three boxes, since a row is text
2. BThe title box, holding Big Ones
3. CThe artist_id box, holding 3
4. DThe album_id box, holding 5