which cannot contain NULL?

View the Exhibit and examine the data in the PRODUCTS table. Which statement would
add a column called PRICE, which cannot contain NULL?

View the Exhibit and examine the data in the PRODUCTS table. Which statement would
add a column called PRICE, which cannot contain NULL?

A.
ALTER TABLE products ADD price NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT
NULL;

B.
ALTER TABLE products ADD price NUMBER(8,2) DEFAULT 0 NOT NULL;

C.
ALTER TABLE products ADD price NUMBER(8,2) DEFAULT NOT NULL;

D.
ALTER TABLE products ADD price NUMBER(8,2) NOT NULL;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Matheus B. Nascimento

Matheus B. Nascimento

Option “D” works too, if the table is empty.
The questions doesnt especify if the table is empty or not.