​ Structure of the ORDERS Table

question 21

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 orders RIGHT OUTER JOIN customers USING (customer#);
• B) SELECT lastname,firstname,order# FROM orders LEFT OUTER JOIN customers USING (customer#);
• C) SELECT lastname,firstname,order# FROM orders FULL OUTER JOIN customers USING (customer#);
• D) ​both a and c

---

Definitions:

Probable Cause

A reasonable basis for believing that a crime may have been committed, which is necessary for issuing warrants and making arrests.

Preliminary Hearing

An initial hearing in which a judge or magistrate decides if there is probable cause to believe that the defendant committed the crime with which he or she is charged.

Probable Cause

A reasonable basis for believing that a crime may have been committed, used to justify police searches, arrests, and warrants.

Magistrate

A judicial officer with the authority to oversee minor civil disputes and criminal cases.