Search code examples
c#sqlmta

Which of the following SQL statement should you use?

I am brand new to C# and to stackoverflow. I am reviewing questions that I got wrong on a prep test for my MTA certification. Can anyone help me understand what the correct answer is and why? Thank you!

enter image description here

Solution

  • The correct answer would be A

    Firstly it says update only those whose reference is TKY, all answers deal with that.

    Secondly the updated region should be Japan, so that rules out B and C

    Finally the update should only affect customers in Tokyo, so that leaves only A since it's the only one of the four to limit the update with and city='TOKYO'.