A table named AIRPLANES already exists with columns as shown above. Column names in bold always require a value. Which of the following SQL will successfully remove the column named rangeMiles A table named COURSE_REGISTRATION already exists. Which of the following SQL correctly adds the following two columns: 1. regStatus of type CHAR(2) for which a value is always required 2. dropDate of type DATE for which a value is not always required Selected Answers: ALTER TABLE COURSE_REGISTRATION ADD regStatus CHAR(2) NOT NULL ADD dropDate DATE NULL