SQL

Assume that the following SQL statement is executed, ALTER TABLE PUBINFO ALTER COLUMN City SET DEFAULT 'Beirut'; what would happen when the following tuple is inserted: INSERT INTO PUBINFO VALUES ('P002', 'PEARSON', 'CairO'); Select one: A. The value of city column is set to NULL B. The value of city column is set to 'Cairo' C. The value of city column is set to 'Beirut' D. The insertion is rejected