In a Database with a Products Table and Orders Table,you

question 45

Multiple Choice

In a database with a Products table and Orders table,you want to see which products have not been ordered.What type of query should you create?

• A) Select query with a self join.
• B) Update query.
• C) Select query with an outer join.
• D) Append query.

---

Definitions:

Goodwill

An accounting value assigned to the reputation, customer loyalty, or other factors enabling a business to earn higher profits than expected from its assets alone.

Consolidated Balance Sheet

A financial statement showing the aggregated financial position of a parent company and its subsidiaries.

Acquired Company

A company that has been purchased by another entity.

Trading Securities

Marketable securities that a company holds for the purpose of trading in the short term, with the intent of generating profit from price movements.