Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;
A) DML operations can only be performed on the columns belonging to the PUBLISHER table.
B) No DML operations are allowed.
C) DML operations are allowed on both the BOOKS and PUBLISHER tables.
D) DML operations can only be performed on the columns belonging to the BOOKS table.

Question

Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;
A) ​DML operations can only be performed on the columns belonging to the PUBLISHER table.
B) No DML operations are allowed.​
C) ​DML operations are allowed on both the BOOKS and PUBLISHER tables.
D) ​DML operations can only be performed on the columns belonging to the BOOKS table.

Quizplus · Accepted Answer

DML operations can only be performed on the columns belonging to the BOOKS table because ISBN, the primary key from the BOOKS table, is included in the view.

Which Statement About the View Created from the Following SQL