A SQL Workflow from Question to Result: 10 practice questions

Question 1 of 10

The shop asks which bands it sells. The artists table holds artist_id and name, the genres table holds genre_id and name, and the albums table holds album_id, title and artist_id. Which table do you read?

1. Agenres, because that table also has a name column
2. Balbums, because the artist id is stored in that table
3. Cartists, because one row of it is one band
4. Dalbums, because the shop sells records and not bands

Question 2 of 10

In the statement SELECT title FROM albums; which part is the select list?

1. Atitle, the column the result will contain
2. Balbums, the table the rows come from
3. CFROM albums, the whole second line of the statement
4. Dthe semicolon, which closes the statement

Question 3 of 10

You type a finished statement into a SQL client and send it. What does the client do with it?

1. AIt rewrites the statement into a private format first
2. BIt sends the statement on and shows you the answer
3. CIt runs the statement itself and stores the rows
4. DIt holds the statement until more work is asked for

Question 4 of 10

The genres table holds five rows: 1 Rock, 2 Jazz, 3 Metal, 4 Alternative and 5 Blues. What does SELECT name FROM genres; return?

1. AOne column with the five ids, since name is the label
2. BOne row, holding the number of kinds in the table
3. CTwo columns, the id and the kind name, for five rows
4. DOne column, with the five kind names in it

Question 5 of 10

You send SELECT albm_id, title FROM albums; and the database answers that it cannot find a column called albm_id. What came back from the albums table?

1. ANothing: the statement was refused and no row was read
2. BOne row, saying how many columns the table has
3. CThe six rows, with albm_id filled from album_id
4. DThe six titles, with the unknown column left empty

Question 6 of 10

The albums table has the columns album_id, title and artist_id. The statement SELECT albm_id, title FROM albums; came back as an error. Which single change repairs it?

1. AAdd a second semicolon after the name albm_id
2. BPut the two column names the other way round
3. CWrite album_id in place of albm_id
4. DReplace the albums table with the artists table

Question 7 of 10

You need the id of each kind of music first and its label second, but your result shows Rock in the first column. Which statement gives the order you need?

1. ASELECT genre_id, name FROM genres;
2. BSELECT name, genre_id FROM genres;
3. CSELECT genres FROM genre_id, name;
4. DSELECT genre_id FROM genres;

Question 8 of 10

You open your client, run `SELECT title FROM albums;` and the database answers that there is no table called `albums`. The name is spelled correctly and the music store does hold that table. What do you check first?

1. AWhether somebody deleted the six rows of albums
2. BWhether the select list is missing a second column
3. CWhether the statement needs its closing semicolon
4. DWhich database this client connection points at

Question 9 of 10

Accept is a band in the artists table, where its artist_id is 2. The albums table holds album_id, title and artist_id. Which statement lists the records Accept made?

1. ASELECT title FROM albums WHERE artist_id = 2;
2. BSELECT title FROM artists WHERE artist_id = 2;
3. CSELECT name FROM artists WHERE album_id = 2;
4. DSELECT title FROM albums WHERE title = 'Accept';

Question 10 of 10

The report needs one row for each of the five kinds of music. Your statement came back without an error, but the result has forty rows. What does that tell you?

1. AThe result is wrong even though no error was raised
2. BThe database added rows of its own to fill the table
3. CThe kinds of music were counted twice by the client
4. DNothing: a result without an error is the right answer