SQL statements were executed in the following order:

CREATE TABLE fmaster (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE ftrans (id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE); INSERT INTO fmaster VALUES (1, 'itemA'); INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE); Select the two SQL statements that will generate an error when executed next.

Question

SQL statements were executed in the following order:

CREATE TABLE fmaster (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE ftrans (id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE); INSERT INTO fmaster VALUES (1, 'itemA'); INSERT INTO ftrans VALUES (1, 1, CURRENT_DATE); Select the two SQL statements that will generate an error when executed next.

Accepted Answer

B. INSERT INTOfmaster VALUES (1, 'itemB'); C. DELETE FROMfmaster;

Answer

A. DROP TABLEftrans;

Answer

D. UPDATEfmaster SET name = NULL;

Answer

E. INSERT INTOftrans VALUES (1, 2, NULL);

SQL statements were executed in the following order: CREATE TABLE fmaster (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE ftrans (id INTEGER REFERENCES fmaster (id), stat INTEGER, date DATE)…

Question

Options

How the community answered

Community Discussion