Which SQL statement can be executed based upon the view created from the following command, assuming no constraints exist on the underlying table? CREATE VIEW prices AS SELECT isbn, title, cost, retail, retail-cost profit FROM books;
a. INSERT INTO prices (title, cost, retail, profit)VALUES ('A NEW BOOK', 49.99, 69.99, 20);
b. INSERT INTO prices (title, cost, retail, profit)VALUES ('A SECOND BOOK', 49.99, 39.99, -10);
c. INSERT INTO prices (title, cost, retail)VALUES ('A NEW BOOK', 49.99, 69.99);
d. none of the above
c
You might also like to view...
When Company A discounts, with recourse, a note to Company B, Company B has a contingent liability until the note is paid
Indicate whether the statement is true or false
Which of the following statements is true regarding a company's segment margin?
A) It is primarily used to make short-term decisions such as cost-volume-profit (CVP) analysis and special order decisions. B) It ignores all fixed costs. C) It is primarily a measure of long-term profitability. D) It should not be used to make decisions on whether or not to drop a product line.
Trendline Architects' core competency is building multi-family housing in urban areas. This competency is based primarily on the decisions made by the company's top management over several years to focus on building in densely populated cities. This process is called
A. dependence complexity. B. path dependence. C. causal dependence. D. path immobility.
Members of new teams often pay more attention to the tasks of the team than to the relationships among the team members.
Answer the following statement true (T) or false (F)