Contents of the ORDERS Table

question 56

Multiple Choice

Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?​

• A) ​SELECT * FROM orders WHERE shipdate IS NOT NULL ORDER BY customer#,order#;
• B) ​SELECT * FROM orders WHERE shipdate IS NULL ORDER BY customer#,order#;
• C) ​SELECT * FROM orders WHERE shipdate IS NOT NULL ORDERED BY customer#,order#;
• D) ​SELECT * FROM orders WHERE shipdate IS NOT NULL SORTED BY customer#,order#;

---

Definitions:

Extrinsic Reinforcement

Motivation or reward that comes from outside an individual, such as money, grades, or praise, which can influence behavior.

Higher-Order Reinforcement

A process in which reinforcement is given for behavior that meets or exceeds a previously established criterion of performance.

Secondary Reinforcement

A conditioning process where a stimulus reinforces a behavior after it has been associated with a primary reinforcer.

Shaping

A method of operant conditioning by which successive approximations of a desired behavior are reinforced until the exact behavior is achieved.