Which statement adds a column called SALARY to the EMPLOYEES table having 100 rows, which cannot contain null?

Which statement adds a column called SALARY to the EMPLOYEES table having 100 rows, which cannot contain null?
A. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT 0 NOT NULL;
B. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;
C. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) DEFAULT NOT NULL;
D. ALTER TABLE EMPLOYEES
ADD SALARY NUMBER(8,2) NOT NULL;

Download Printable PDF. VALID exam to help you PASS.