SQL Quiz #4 - General Concepts

Question 1 of 10

What does SQL stand for?

Question 2 of 10

What does the following command do?
SELECT Type FROM Cakes

Question 3 of 10

How do you select all the values from the Cakes table?

Question 4 of 10

How can you select all the records in the Cakes table, where the cake name is “Strawberry Cake”?

Question 5 of 10

What keyword do you use to specify that only unique rows can appear in the result set?

Question 6 of 10

Select the correct order in which the following cakes will appear when this command is executed:
SELECT * FROM Cakes ORDER BY Name

Strawberry Cake
Vanilla Ice-cream Cake
Banana Cake

Question 7 of 10

Which of the following commands is used to delete all the rows in the Cakes table?

Question 8 of 10

What does the following command do?
SELECT COUNT(*) FROM Cakes

Question 9 of 10

A primary key may have NULL values.

Question 10 of 10

Which of the following selects all the cakes that start with letter B?

SQL Quiz #4 – General Concepts