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

If select * from clients shows from left to right first_name, last_name, phone_number, which of the following insert statement is correct?:
insert into clients values (1234556,”Mark”,”Johnson”)
insert into clients values (”Mark”,”Johnson”,123456)
insert into clients values (Mark,Johnson,123456)

Question 2

Can an insert update an existing row?:
Yes.
No.

Question 3

Can an insert delete a row?:
Yes.
No.

Question 4

Can an insert show a row?:
Yes.
No.

 

 

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