Which SQL statement can be executed based upon the view created from the following command,assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;
A) INSERT INTO prices (title,cost,retail,profit)
VALUES ('A NEW BOOK',49.99,69.99,20);
B) INSERT INTO prices (title,cost,retail,profit)
VALUES ('A SECOND BOOK',49.99,39.99,-10);
C) INSERT INTO prices (title,cost,retail)
VALUES ('A NEW BOOK',49.99,69.99);
D) none of the above

Question

Which SQL statement can be executed based upon the view created from the following command,assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;
A) INSERT INTO prices (title,cost,retail,profit)
VALUES ('A NEW BOOK',49.99,69.99,20);
B) ​INSERT INTO prices (title,cost,retail,profit)
VALUES ('A SECOND BOOK',49.99,39.99,-10);
C) ​INSERT INTO prices (title,cost,retail)
VALUES ('A NEW BOOK',49.99,69.99);
D) ​none of the above

Quizplus · Accepted Answer

The view prices was created with only three columns - isbn, title, and profit (which is calculated from the cost and retail columns). Therefore, the INSERT statement can only insert values into these three columns. Option A and B both have four columns (title, cost, retail, profit) and cannot be executed on this view. Option C has the correct number of columns and matches the data types of the columns in the view.

Which SQL Statement Can Be Executed Based Upon the View