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.
Consider the fragment “
set phone_number=4934455599988 where first_name = ‘Aamir’“. Which of the following is the most true?:
One or more first names are going to change.
phone_number must be equal to 4934455599988 to apply.
One or more phone numbers are going to change.
One phone number only is going to change.
Which of the following fragments is not correct:
set first_name= aamir
Which of the following fragment is preferable?:
In the statement “
update customers set email='[email protected]' where first_name = ‘Aamir’”:
The table is customers, the column to change is first_name, the condition is on email.
The table is customers, the column to change is email, the condition is on first_name.
Which of the following syntax is correct:
set email='[email protected]',phone_number=34455599988
set email='[email protected]' and phone_number=34455599988
set email='[email protected]' or phone_number=34455599988
Which fragment is correct when you want to divide all revenues by 2:
set revenue = revenue * 2
divide revenue by 2
set revenue = revenue / 2
select revenue = revenue /2
What happens when you do not use “where” in an update statements:
The update is not executed.
It updates all the rows in the table.
It updates all the columns in the table.
It updates all the fields in the table.
It does not execute.