> > >

PostgreSQL MCQs

Consider the following empty table:
CREATE TABLE example (
a integer,
b integer,
c integer,
UNIQUE (a, c)
);
Which of the following inserts will cause an error?

insert into example (a, b, c) values (1, 2, 3), (1, 2, 4);

insert into example (a, b, c) values (1, 2, 3), (3, 3, 3);

insert into example (a, b, c) values (1, 1, 1), (3, 3, 3);

insert into example (a, b, c) values (1, 2, 3), (1, 4, 3);

None will cause an error

Answer

Correct Answer:

insert into example (a, b, c) values (1, 2, 3), (1, 4, 3);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

PostgreSQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it