Q8) -Which code snippet will alter the table LOCATIONS and add a column named Address, with datatype VARCHAR2 (100)? AALTER TABLE locations ADD (address varchar2 (100)) B -ALTER TABLE location5 ADD COLUMN {addre varchar2(100)); C-MODIFY TABLE location ADD COLUMN (addre53 varchar2 (100)) D- None of the above 09)-Which of the following is true about subqueries? ASubueries could be used for Top-N analysis B Subueries can be of two types-single-row subquery and multiple-row subquery C-The outer and inner queries can get data from different table: D-All of the above. Show