Question

Ariya wants to add another column'Gender' in the already existing table 'CUSTOMERS'. She has written the following statement. However, it has errors. Rewrite the correct statement.

'MODIFY TABLE CUSTOMERS GENDER' char(1);

Answer 1

ALTER TABLE CUSTOMERS

ADD GENDER char(l);