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?
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’)
|
Download Printable PDF. VALID exam to help you PASS. |
 |