Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which SQL statement correctly updates a transactions table to change a flag from 'Y' to 'N'?
A
MERGE transactions SET active_flag = 'N' WHERE active_flag = 'Y'
B
UPDATE transactions SET active_flag = 'N' WHERE active_flag = 'Y'
C
MODIFY transactions SET active_flag = 'N' WHERE active_flag = 'Y'
D
REPLACE transactions SET active_flag = 'N' WHERE active_flag = 'Y'
