Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

© examsnet.com

Question : 18 of 50

Marks: +1, -0

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

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

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

Go to Question:

Advertisements