Free BEC Subtest II Questions and Answers — Questions and Answers
Question 1: What is a database?
- A base layer for storing items
- A type of a disk
- A computer mechanism for storing and retrieving data (Correct answer)
- A part of a computer closest to data
Correct answer: A computer mechanism for storing and retrieving data
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. It is designed to efficiently store, manage, and retrieve large amounts of data, allowing users to easily access, manipulate, and update information. This makes it a fundamental tool for data management in various applications, serving as a central repository for digital information.
Question 2: A database of auto parts has two tables. The first table includes all the different parts. The second table includes all the different types of vehicles. <br>Some parts can be used in more than one vehicle, while all vehicles consist of more than one part. This describes which type of table association?
- Many-to-many (Correct answer)
- All-to-many
- Many-to-one
- Many-to-all
- One-to-many
Correct answer: Many-to-many
A many-to-many relationship in a database occurs when multiple records in one table can be associated with multiple records in another table. In this scenario, one auto part can be used in many different vehicles, and one vehicle consists of many different parts. This perfectly describes a many-to-many association between the 'parts' table and the 'vehicles' table, requiring an intermediary table to resolve the relationship.
Question 3: _____ is a field in a database table (or a combination of fields) that has a unique value.
- A foreign key
- An identifier
- An alternate key
- A secondary key
- A primary key (Correct answer)
Correct answer: A primary key
A primary key is a special relational database table column (or a combination of columns) that has a unique value for each record in the table. Its main purpose is to uniquely identify each row, ensuring data integrity by preventing duplicate entries and providing a reliable way to link related data across different tables. This uniqueness is fundamental for efficient data retrieval and management.
Question 4: What does the Consumer Price Index measure?
- Changes in unemployment
- Changes in tax rates
- Changes in depreciation
- Changes in the price level of an economy (Correct answer)
- Changes in the quantity supplied in an economy
Correct answer: Changes in the price level of an economy
The Consumer Price Index (CPI) is a measure that examines the weighted average of prices of a basket of consumer goods and services, such as transportation, food, and medical care, purchased by urban consumers. It is a key economic indicator used to assess inflation and deflation, reflecting changes in the price level of an economy over time. The CPI helps gauge the purchasing power of a country's currency.
Question 5: Why does a higher interest rate affect the business cycle?
- It takes longer to get a loan
- Banks have less money to loan
- Individuals will not apply for a loan
- If the interest rates high, individuals will borrow less because it costs more (Correct answer)
Correct answer: If the interest rates high, individuals will borrow less because it costs more
Higher interest rates increase the cost of borrowing money for both individuals and businesses. This discourages borrowing for investments, purchases, and expansion, as the financial burden becomes greater. Consequently, reduced consumer spending and business investment lead to a slowdown in economic activity, negatively impacting the business cycle and potentially leading to slower growth or recession.
Question 6: Which of the following is a lagging economic indicator?
- industrial production
- number of employees by sector
- balance of trade (Correct answer)
- gross national product
Correct answer: balance of trade
Lagging economic indicators are measures that change after the economy has already begun to follow a particular pattern or trend, confirming a past economic event. The balance of trade, which reflects a country's net exports, typically responds to economic shifts rather than predicting them, making it a lagging indicator. Other options like industrial production and gross national product are generally coincident indicators.
Question 7: An increase in inflation will lead to a(n) _____ in bond/debt prices.
- increase
- unknown change
- decrease (Correct answer)
- large change
Correct answer: decrease
When inflation increases, the purchasing power of future fixed interest payments from bonds decreases, making existing bonds less attractive. Investors demand a higher yield to compensate for this loss of purchasing power, which means the market price of existing bonds with lower fixed interest rates will fall. This inverse relationship between interest rates (influenced by inflation expectations) and bond prices is a fundamental principle in finance.
Free BEC Subtest II Questions and Answers
What is a database?