Which statement would add a column called PRICE, which cannot contain NULL?

Prev Question
Next Question

View the Exhibit and examine the data in the PRODUCTS table.

Exam 1Z0-047 - Which statement would add a column called PRICE, which cannot contain NULL?

Which statement would add a column called PRICE, which cannot contain NULL?

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

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

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

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

Prev Question
Next Question

Leave a Reply

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