The Select Operation

question 5

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)creates a subset consisting of rows in a table.

---

Definitions:

Maturity

The final payment date of a loan or financial instrument, at which point the principal (and all remaining interest) is due to be paid.

Interest Rate Risk

The risk that changes in interest rates will adversely affect the value of an investment, particularly relevant for fixed-income securities.

Variable-Rate Assets

Assets that earn interest at rates which adjust over time based on prevailing market conditions.

Cash Equivalent

Short-term, highly liquid investments that are readily convertible to known amounts of cash and are subject to an insignificant risk of changes in value.