The Following SQL2 Command Is Executed: CREATE VIEW CUST_SD2 AS

question 18

Multiple Choice

The following SQL2 command is executed: CREATE VIEW CUST_SD2 AS
SELECT * FROM CUSTOMER
WHERE Cregion = 'SD'
WITH CHECK OPTION
There is a request to execute the following SQL2 command:
UPDATE CUST_SD2
SET AGE = AGE +1,Cregion = 'LA' WHERE CNAME = 'BLACK'
Select the most appropriate statement:

• A) After execution of this query, SELECT * from CUST_SD2 will show a value of 41 for BLACK
• B) After execution of this query, SELECT * from CUSTOMER will show a value of 41 for BLACK
• C) Both of the above
• D) No update took place

---

Definitions:

Process Cost System

A method in accounting for assigning costs to like products, which are produced en masse and in a continual manner.

Computer Chips

Small semiconductor devices made of silicon or other materials that contain integrated circuits used in the manufacturing of electronic devices.

Process Costing

A costing method used where similar products are produced in a continuous process, assigning average costs to each unit.

Job Order Costing

An accounting methodology used to track the expenses of creating a specific product or providing specific services and assign those costs to the products or services.