SQL Commands - UPDATE Statements

Order the following Images to create a valid UPDATE statement

• 1, 2, 3

• 2, 3, 1

• 3, 2, 1

• 3, 1, 2

What is ABC the name of?

UPDATE ABC

SET C1 = “V”

WHERE C2 = “V”

• The Database

• The User

• The Table

• The Columns

What do C1 and C2 represent?

UPDATE ABC

SET C1 = “V”

WHERE C2 = “V”

• The Database

• The User

• The Table

• The Columns

What is the purpose of line as indicated?

UPDATE ABC

SET C1 = “V” <-

WHERE C1 = “V”

• To specify what Column to Update

• To specify what Row to Update

• To specify what Table to Update

• To specify what Database to Update

What is the purpose of line as indicated?

UPDATE ABC

SET C1 = “V”

WHERE C1 = “V” <-

• To specify what Column to Update

• To specify what Row to Update

• To specify what Table to Update

• To specify what Database to Update

Given the following Table, what will the SELECT statement retrieve after both SQL statements are run?

UPDATE Contacts SET Email = '[e-mail]'

SELECT Phone FROM Contacts WHERE Name = 'Jane'

• [e-mail]

• [e-mail]

• [e-mail]

• [e-mail]

Answer explanation

If no WHERE Clause is specified, ALL rows will be updated with the new value

Which line in the following Statement has an error

1. UPDATE Contacts

2. SET Emial = '[e-mail]'

3. WHERE Name = 'Jane'

• 1

• 2

• 3

The table has been renamed from "Contacts" to "Phonebook".

Which line needs to change?

1. UPDATE Contacts

2. SET Phone = '12345678'

3. WHERE Name = 'Jane'

• 1

• 2

• 3

Write the new updated line

(a)  

SET Phone = '12345678'

WHERE Name = 'Jane'

How do I modify SET clause in the update statement to also update Jane's email?

UPDATE Phonebook

SET Phone = '12345678' <-

WHERE Name = 'Jane'

• SET

  Email = 'email'; Phone = 'number'

• SET

  Phone = 'number' + Email = 'email'

• SET

  Email = 'email', Phone = 'number'