4.11 Answer the following multiple choice questions. 1. With respect to data war

Question

4.11 Answer the following multiple choice questions. 1. With respect to data warehouses, databases, and files, which of the following statement(s) is (are) true? a. Analyzing large amounts of data for strategic decision making is often referred to as strategic processing. b. Databases were developed to address the proliferation of master files, which were cre- ated each time a need for information arose. c. A DBMS manages and controls the interface between stored data and the application programs that use the data. d. Since data warehouses are only used for transaction processing, they are updated in real time rather than periodically e. Few mainframes and servers use database technology, and database use in personal computers is growing slowly 2. With respect to data warehouses, databases, and files, which of the following statement(s) is (are) true? a. A problem with databases is data inconsistencies, as the same data is stored in two or more master files. b. A database system consists of the database, the DBMS, and the application programs that access the database through the DBMS c. Data mining is using queries to investigate hypothesized relationships among data. d. A data warehouse is one or more very large databases containing both detailed and summarized data for a number of years. e. Data sharing refers to data and the programs that use them being independent of each other, each can be changed without changing the other. 3. With respect to data warehouses, databases, and files, which of the following statement(s) is (are) true? a. Cross-functional analysis refers to combining master files into larger pools of data so can access the data. b. In the master file approach, data is an organizational resource used by and managed for the entire organization, not just the originating department c. Data warehouses complement transaction processing databases by providing support for strategic decision making. d. OLAP is using sophisticated statistical analysis to find unhypothesized relationships in data. e. To avoid outdated, incomplete, or erroneous data, management needs policies and procedures that ensure scrubbed data. 4. With respect to data warehouses, databases, and files, which of the following statement(s) is (are) true? a. The database controller (DBC) is responsible for coordinating, controlling, and man- aging the database. b. Since strategic decision making requires access to large amounts of historical data, c. Data warehouses minimize redundancy, while transaction processing databases are d. Data validation controls that ensure input accuracy are one of the most time-consum- e. While it is important to regularly backup transaction processing databases, that is not organizations are building separate databases called data warehouses. ly redundant to maximize query efficiency ing and expensive steps in creating a data warehouse. the case with data warehouses.

Explanation / Answer

ANSWER:

1. a, true.

Key essential management is a nonstop procedure that include making technique to achieve objectives and adjust methodologies in view of watch results.
For example, the supervisor of a pizza canteen may have the aim of increasing deal and decide to execute a method of offering inferior costs on specific items amid off hours to draw in additional clients. Following a month of looking for after the fresh system, supervisor can take a gander at deals information for the month and charge whether the method bring about expanding deal and later keep the original price plot or regulate their procedure.
1. b
true.
For a long time organization made new proceedings and project each time a data require emerge.
The result was a huge increase in the amount of ace papers that relations put away.
1.C
true.
A database management structure (DBMS) is program that controls the ability, association, and recovery of information. ... For instance, after an application inquiries a table, the database may utilize a record to place the asked for lines, read the information into memory, and perform numerous different strides previously restoring an result to the client.
1. d.
false
servers and mainframes may have centralized databases
false
An information storeroom is a social record that is planned for question and examination as opposed to for swap handling.
1.e.

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.