> > >

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