SQL

How to add multiple columns like Brand, ReleaseDate, and CompanyNo to PRODUCT table? Select one: A. Alter table PROdUCt AdD (Brand ChAR(8)), ADD(Releasedate DAte), ADD (CompanyNo NUMBER(8)); B. ALTER table PROdUCt AdD (Brand ChAR(8), Releasedate DATE, CompanyNo NUMBER(8)); C. ALTER TABLE PRODUCT ADD (Brand CHAR(8), Releasedate(DATE), ADD (CompanyNo NUMBER(8)); D. First and Second one Question 8 Flag question To change the datatype of Category column in PRODUCT table, which is the correct statement: Select one: A. ALTER table PRODUCT MODIFY Category CHAR(8); B. ALTER tABLE PROdUCT UPdAte Category CHAR(8); C. ALTER TABLE PRODUCT RENAME Category CHAR(8); D. ALter table PROdUCt REChange Category ChaR(8)