SQL WHERE Condition – Quiz

For each question below, select the best answer. To select the best answer, click on the circle located on the left of this answer. When all questions are answered, click on the Submit button

Question 1

With the condition “where last_name like “ra%”, rows are displayed when last_name:
equals rama, radada, or dara.
equals rama, radata, or darada.
equals rama, radata, or ramama.
equals ra, rata, mara, or rara.

Question 2

With the condition “where last_name like “%ra”, rows are displayed when last_name:
equals rara, radada, dara.
equals rara, tadara, ramara.
equals rama, radata, darada.
equals ra, rata, mara, rara.

Question 3

With the condition “where last_name like “%ra%”, rows are not displayed when last_name:
equals rara.
equals mara.
equals narmarda.
equals maramra.

Question 4

With the condition “where total_sales >= 100”, rows are not displayed when total_sales:
equals 100.
equals 99.
equals 121.
equals 101.

Question 5

With the condition “where total_sales > 100”, rows are displayed when total_sales:
equals 100.
equals 121.
equals 99.

 

 

Once you have completed the quiz, calculated your score and reviewed your answers, I invite you to go to the next lesson: Combining Conditions.
 
Share on:

Something not clear? Ask your question here:

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

 
 

Author:
Last udpated: September 10, 2017
Created: September 2, 2014