Which SQL Statement Can Be Executed Based Upon the View

question 125

Multiple Choice

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

---

Definitions:

Contracts Fraud

Contracts fraud involves the intentional deception or misrepresentation made by a party in a contract to gain a financial advantage or to harm the other party, often relating to the falsification or concealment of information.

Business Organization

The structure and framework within which an enterprise operates, detailing the roles, relationships, and responsibilities of its entities.

Pool Their Resources

To combine assets, funds, or talents of a group of people for a common purpose or to achieve a common goal.

Business Trust

A legal entity formed under trust law to pursue business activities, offering participants flexibility in management and investment.