Question

Pick all INSERT statements that will work correctly for the following table:

CREATE TABLE test (
    nr     int,
    lp     int,
    symbol char(2) not null default 'FV',
    ayear  int,
    PRIMARY KEY(nr, lp)
);

Cosmo · Accepted Answer

- "INSERT INTO test VALUES (2001)" is invalid as violates the primary key integrity
- "INSERT INTO test VALUES (2, 5,, 2001)" — is invalid because there are only three types of values allowed to be used inside brackets: some actual value, NULL and DEFAULT.

Cosmo · Accepted Answer

INSERT INTO test VALUES (3, 4, 'AB', 2000)

Cosmo · Accepted Answer

INSERT INTO test(nr, lp) VALUES (1, 6)

Cosmo · Accepted Answer

INSERT INTO test(nr, lp, symbol) VALUES (18, 6, 'KJ')

Cosmo · Accepted Answer

INSERT INTO test(nr, lp, ayear, symbol) VALUES (9, 7, 2002, 'PR')

Cosmo · Answer

INSERT INTO test VALUES (2, 5,, 2001)

Cosmo · Answer

INSERT INTO test VALUES (2001)

Follow CodeGalaxy

Mobile Beta