WorksheetsSQL Commands - UPDATE Statements
Total questions: 10
Worksheet time: 6mins
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 = 'james2@home.com'
SELECT Phone FROM Contacts WHERE Name = 'Jane'
Which line in the following Statement has an error
1. UPDATE Contacts
2. SET Emial = 'james2@home.com'
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'
