PrepAway - Latest Free Exam Questions & Answers

Which of the following statements will successfully insert a record into table TAB1?

If table TAB1 is created using the following statement:
CREATE TABLE tab1 (col1 INTEGER NOT NULL,
col2 CHAR(5),
CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))
Which of the following statements will successfully insert a record into table TAB1?

PrepAway - Latest Free Exam Questions & Answers

A.
INSERT INTO tab1 VALUES (0, ‘abc’)

B.
INSERT INTO tab1 VALUES (NULL, ‘abc’)

C.
INSERT INTO tab1 VALUES (ABS(2), ‘abc’)

D.
INSERT INTO tab1 VALUES (DEFAULT, ‘abc’)


Leave a Reply