SQL DELETE Statement and Data Cleaning Quiz

What SQL statement is used to remove data from a table?

• INSERT

• UPDATE

• DELETE

• SELECT

What is the primary key in the song table?

• title

• year_released

• song_id

• artist

How many songs in the table have an unknown release year?

• 10,000

• 5,320

• 4,680

• 1,000

What clause is used in a DELETE statement to specify which rows to remove?

• GROUP BY

• ORDER BY

• WHERE

• HAVING

What happens if you execute a DELETE statement without a WHERE clause?

• It does nothing.

• It deletes the last row in the table.

• It deletes the first row in the table.

• It deletes all rows in the table.

What is the tempo of a song with a tempo value of 0 beats per minute?

• Silent

• Slow

• Moderate

• Fast

How many songs had a tempo of 0 beats per minute?

• 12

• 4,668

• 5,320

• 1

What is the expected range for loudness values in the song table?

• Positive numbers

• Zero

• Negative numbers

• Any number

How many songs had a positive loudness value?

• 4,668

• 5,320

• 12

• 1

What was the average tempo range after cleaning the data?

• 60 beats per minute

• 90 beats per minute

• 120 beats per minute

• 150 beats per minute