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:

Replicate

To duplicate or reproduce an experiment, study, or procedure to verify its results.

Empirical Investigation

A research method that relies on direct or indirect observation and experience to gather knowledge or conclusions.

Independent Verification

The process of having a third party check and confirm the accuracy or validity of findings or data to ensure objectivity and reliability.

Hypothesis Testing

A method in statistics used to determine whether there is enough evidence to reject a null hypothesis about a population parameter.