Assuming the account number is 2, which of the following modifies the pin column 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

c) UPDATE accounts SET pin = 1243 WHERE accountNumber = 2

Computer Science & Information Technology

You might also like to view...

Answer the following questions true (T) or false (F)

1. The controlling expression for a switch statement may not be of type double. 2. The if statement is more general purpose and flexible than the switch statement. 3. The loop repetition condition of a for statement is tested at the end of each pass.

Computer Science & Information Technology

?Which of the following Flash player parameters recognizes a movie so that it can be referenced and has a value oftext?

A. ?id B. ?flashvar C. ?name D. ?wmode

Computer Science & Information Technology