× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
14
o
6
6
G
3
c
3
q
3
m
3
j
3
s
2
b
2
j
2
u
2
New Topic  
kekule kekule
wrote...
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 119 times
2 Replies
Replies
Answer verified by a subject expert
taniaaaaaataniaaaaaa
wrote...
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...
6 years ago
White Heavy Checkmark Marking this solved
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1121 People Browsing
Related Images
  
 329
  
 5072
  
 230
Your Opinion
Which country would you like to visit for its food?
Votes: 261

Previous poll results: What's your favorite math subject?