consider the following empty table create table example a integer b..., PostgreSQL RDBMS, Databases

Test
- Model Test
Index

Question: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?

A insert into example (a, b, c) values (1, 2, 3), (1, 2, 4); 
B insert into example (a, b, c) values (1, 2, 3), (3, 3, 3); 
C insert into example (a, b, c) values (1, 1, 1), (3, 3, 3); 
D insert into example (a, b, c) values (1, 2, 3), (1, 4, 3); 
E None will cause an error

/59

+ AnswerD

+ Report

Descriptive on PostgreSQL RDBMS Ebook

Total Preview: 581

Question: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?

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

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

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

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

E None will cause an error

D