The Select Operation

question 61

Multiple Choice

The select operation:

• A) combines relational tables to provide the user with more information than is otherwise available.
• B) creates a subset consisting of columns in a table.
• C) identifies the table from which the columns will be selected.
• D) creates a subset consisting of all records in the file that meet stated criteria.
• E) specifies the content of the database.

---

Definitions:

Future Amount

The predicted amount of money that an investment will grow to over a period of time, considering factors like interest rates and compounding.

Equivalent Amount

The same value or quantity expressed in a different way or form.

Interest Rate

A proportion of an amount of money that is charged for borrowing or using it, usually presented as a yearly rate.

Rate of Return

The percentage gain or loss on an investment over a specified period.