Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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'