Answered

CREATE VIEW , AS SELECT * FROM Invoices JOIN Vendors ON Invoices.VendorID = Vendors.VendorID
WHERE InvoiceTotal - PaymentTotal - CreditTotal > 0;
(a) Will create an updatable view
(b) Will create a read-only view
(c) Will create a view through which you can update or insert rows, but not delete rows
(d) Will fail because the SELECT statement returns two columns named VendorID



Answer :

Other Questions