​ Structure of the ORDERS Table

question 70

Multiple Choice

​
Structure of the ORDERS table
Structure of the CUSTOMERS table
​
-​Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

• A) ​SELECT * FROM orders,customers;
• B) SELECT lastname,firstname,order# FROM orders NATURAL JOIN customers;
• C) SELECT lastname,firstname,order# FROM orders,customers WHERE orders.customer# = customers.customer#;
• D) ​all of the above

---

Definitions:

Long-Term Investments-Trading

Long-term investments-trading refers to the purchase of securities with the intention of holding them for an extended period to benefit from their long-term appreciation, dividends, or interest earnings.

Bonds

Fixed-income securities that represent a loan made by an investor to a borrower, typically corporate or governmental.

Interest Accrued

The amount of interest that has accumulated over time but has not yet been paid or charged.

Par Value

The nominal value of a bond or stock as declared by the issuer, which might not represent its actual market value.