Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q120: DML operations are not allowed on views
Q121: Which type of view is created from
Q122: DML operations are not allowed on a
Q123: Views are database objects that store data.
Q124: DML operations are not allowed on a
Q126: The subquery used to create a(n)_ view
Q127: A complex view cannot contain any group
Q128: Column aliases can be used in the
Q129: A(n)_ view only exists while the SELECT
Q130: Which type of view is created with