× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
kekule kekule
wrote...
Go to Answer
Posts: 687
Rep: 0 0
6 years ago
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.
Read 105 times
2 Replies
Replies
Answer verified by a subject expert
taniaaaaaataniaaaaaa
wrote...
#1
Top Poster
Posts: 946
Rep: 5 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

kekule Author
wrote...
#2
6 years ago
White Heavy Checkmark Marking this solved
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1083 People Browsing
 126 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 43
  
 306
  
 1186
Your Opinion
Who will win the 2024 president election?
Votes: 3
Closes: November 4
Previous poll results: Where do you get your textbooks?