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)
);
Explanation
- "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.
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback