Question: Assume that the SQL Data Definition Language (DDL) and Data Manipulation Language (DML) statements below are executed successfully in an empty database: CREATE TABLE V

Assume that the SQL Data Definition Language (DDL) and Data Manipulation Language (DML) statements below are executed successfully in an empty database: CREATE TABLE V A INTEGER PRIMARY KEY, B DATE NOT NULL, C VARCHAR(10), D VARCHAR(10), UNIQUE (C), FOREIGN KEY (D) REFERENCES V (C) CREATE TABLE W ( E VARCHAR(10), F INTEGER, PRIMARY KEY (E, F). FOREIGN KEY (F) REFERENCES V (A) INSERT INTO V (A, B, C, D) VALUES (1, 2020-10- 01', 'a', null); INSERT INTO V (A, B, C, D) VALUES (2, 2020-10- 02', 'b', 'a') : INSERT INTO V (A, B, C, D) VALUES (3, CURRENT DATE, 'a', 'b') INSERT INTO W (E, P) VALUES ('x'. 1) INSERT INTO W (E,F) VALUES ('x', 2): INSERT INTO WE, F) VALUES ('y'. 2) Which of the following tuples would NOT be permitted in Vor w (as indicated)? DATE, 'c', 'b'); INSERT INTO W (E, F) VALUES ('x', 1); INSERT INTO W (E, F) VALUES ('x', 2); INSERT INTO W (E, F) VALUES ('y', 2); Which of the following tuples would NOT be permitted in Vor W (as indicated)? V: (3, 2020-10-01, 'd', null) W: (7,3) W: (x, 5) V: (4, 2020-09-30, 'e'c')
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
