Question 87:
You execute the SQL statement:
What is the outcome?
Answer options:
A. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column. B. It succeeds and CITY can contain only "˜SEATTLE` or null for all rows. C. It fails because the condition for the CNAMES constraint is not valid. D. It succeeds and an index is created for CITIZEN_ID.