SQL SELECT – 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

In “select * from clients”, “*” means:
we want to select all the rows in the table.
we want to select all the columns in the table.
we want to select all the fields in the database.
we want to select all the tables in the database.

Question 2

In “select * from clients”, clients is:
the name of a column.
the name of the database.
the name of a field.
the name of the table.

Question 3

select first_name, last_name, phone_number from clients”, last_name is:
a row.
a column.
a table.
a field.

Question 4

If revenue is a number, which fragment is the most appropriate:
where revenue = “123456”
where revenue = /123456
where revenue = 123456

Question 5

In the following query “select first_name from clients where state=’karnataka’”:
we show the column state.
we show both the columns state and first_name.
we show all rows in the clients table
we show the column first_name
we show rows in the state table

Question 6

Which fragment is correct:
where company_code = “Asdf 1!”.
where company_code = /Asdf 1!.
where company_code = Asdf 1!.
where company_code = Asdf1.

 

 

Once you have completed the quiz, calculated your score and reviewed your answers, I invite you to go to the next lesson: SQL DISTINCT, ORDER BY, COUNT.
 
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