​ Structure of the ORDERS Table

question 32

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-​Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table,and,if the customer has placed an order that is contained in the ORDERS table,the order# of any order each customer has placed?

• A) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NOT NULL;
• B) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# (+)= customers.customer#;
• C) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# = customers.customer# (+);
• D) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NULL;

---

Definitions:

Normative Influence

The impact of social norms and expectations on an individual's behavior, often leading to conformity.

Informational Influence

A process by which individuals change their opinions or behaviors to align with those of a group or authority figure, based on the information or evidence presented.

Defensive Influence

The impact of psychological defense mechanisms in shaping an individual's behavior or response to certain stimuli or situations.

Self-fulfilling Prophecy

A prediction that directly or indirectly causes itself to become true due to the positive feedback between belief and behavior.