Assuming the account number is 2, which of the following statements modifies the PIN field in the Accounts table?

a) SELECT PIN FROM Accounts WHERE AccountNumber = 2
b) SELECT Accounts FROM AccountNumber = 2 WHERE PIN
c) UPDATE Accounts SET PIN=1243 WHERE AccountNumber = 2
d) UPDATE PIN=1243 SET AccountNumber = 2 WHERE Accounts

Answer: C

Computer Science & Information Technology

You might also like to view...

?To communicate with a friend while you're on the go or send messages to family members, you can use ____.

A. ?clips B. ?email C. ?spam D. ?a wiki

Computer Science & Information Technology

Changes to the table structure are made on the Table Tools ___________ tab.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology