× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
New Topic  
Ejaylcuk Ejaylcuk
wrote...
Posts: 652
Rep: 0 0
6 years ago
Which statement about the view created from the following SQL statement is correct? CREATE VIEW balancedue AS SELECT customer, order, SUM(quantityretail) amtdue FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books GROUP BY customer, order;
 a. No DML operations can be performed through the view.
  b. DML operations can only be performed on the CUSTOMERS table since it is the primary key for the view.
   c. Only rows can be added through the view  no other DML operations are allowed.
  d. none of the above
Read 44 times
1 Reply

Related Topics

Replies
wrote...
6 years ago
a
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1097 People Browsing
 101 Signed Up Today
Related Images
  
 5649
  
 615
  
 1801
Your Opinion