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

Verified
Correct Answer:
Verified
Q6: An inline analysis can be used to
Q7: If a view needs to be modified,it
Q8: Which type of view is created with
Q9: "TOP-N" analysis is performed by sorting values
Q10: Which of the following types of views
Q12: Which of the following describes a type
Q13: Views can be used to restrict a
Q14: A(n)_ table is a table that contains
Q15: Which type of view is created from
Q16: Update operations cannot be performed through a