CIW Exam Questions

Which choice demonstrates the correct syntax for the DELETE command?

Which choice demonstrates the correct syntax for the DELETE command?

A.
DELETE MyDatabase WHERE VALUES state=’Kentucky’ AND color=’blue’

B.
DELETE MyDatabase WHERE state=’Kentucky’ AND color=’blue’

C.
DELETE FROM MyDatabase WHERE state=’Kentucky’ AND color=’blue’

D.
DELETE state=’Kentucky’ AND color=’blue’ FROM MyDatabase