Choose all the correct options

Question

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?

Accepted Answer

INSERT INTO tab1 VALUES (ABS(2), 'abc')

Answer

INSERT INTO tab1 VALUES (0, 'abc')

Answer

INSERT INTO tab1VALUES (NULL, 'abc')

Answer

INSERT INTO tab1 VALUES (DEFAULT, 'abc')

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?

0 Discussions

Trending Exams

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?

0 Discussions

Trending Exams

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?