​Contents of ORDERS Table

question 76

Multiple Choice

​Contents of ORDERS table
Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
-​Based upon the contents of the ORDERS table,which of the following SQL statements will display the ship date for order 1006 as April 2,2002?

• A) ​SELECT order#,TO_CHAR(shipdate,'Month DD,YYYY') FROM orders;
• B) ​SELECT order#,TO_DATE(shipdate,'Month DD,YYYY') FROM orders;
• C) SELECT order#,TO_CHAR(shipdate,'Month DY,YYYY') FROM orders;
• D) SELECT order#,TO_DATE(shipdate,'Month DY,YYYY') FROM orders;

---

Definitions:

Underapplied Overhead

The amount by which the actual manufacturing overhead cost exceeds the applied overhead cost.

Job-Order Costing

Job-order costing is a costing method used to determine the cost of manufacturing each custom-made product or job, particularly effective for individual or special products.

Overapplied Overhead

A situation where the overhead allocated to products is more than the actual overhead incurred.

Job-Order Costing

A costing method that assigns manufacturing costs to each individual product or batch, ideal for custom or specialized goods.