es en wa A a a | A developer is trying to add a column named DateOfBirthto the Person table by using the following query: ALTER TABLE Person ADD DateOfBirth date NOT NULL; The developer receives an error message after running the query. How can they resolve the problem without data loss? Change the query as follows: A DROP CONSTRAINT; ALTER TABLE Person ADD DateOfBirth date NOT NULL; Change the query as follows: m B DELETE Person; ALTER TABLE Person ADD DateOfBirth date NOT NULL; Change the query as follows: -=C ALTER TABLE Person ADD DateOfBirth varchar(1) NOT NULL; Change the query as follows: ALTER TABLE Person ADD DateOfBirth date NOT NULL DEFAULT '@1/01/1900' . 2