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. e. 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 more application programs 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, organizations are building separate databases called data warehouses. c. Data warehouses minimize redundancy, while transaction processing databases are purposely redundant to maximize query efficiency d. Data validation controls that ensure input accuracy are one of the most time-consum- ing and expensive steps in creating a data warehouse. e. While it is important to regularly backup transaction processing databases, that is not the case with data warchouses. 5. With respect to databases and files, which of the following statement(s) is (are) true? a. There is a record in the data dictionary that describes each file in the database b. The DOL is used to change the database, such as creating, deleting, and updating records. c. A schema describes data elements and the relationships among them in a user's logi- cal view of the data.

Explanation / Answer

1. a, true.

Key basic leadership is a continuous procedure that includes making techniques to accomplish objectives and adjusting methodologies in view of watched results. For instance, the supervisors of a pizza eatery may have the target of expanding deals and choose to execute a methodology of offering lower costs on specific items amid off hours to draw in more clients. Following a month of seeking after the new system, supervisors can take a gander at deals information for the month and assess whether the technique brought about expanding deals and afterward keep the new value plot or adjust their procedure.

1. b

true.

For a long time organizations made new records and projects each time a data require emerged. The outcome was a huge increment in the quantity of ace documents that associations put away.

1.C

true.

A database administration framework (DBMS) is programming that controls the capacity, association, and recovery of information. ... For instance, after an application inquiries a table, the database may utilize a record to locate the asked for lines, read the information into memory, and perform numerous different strides previously restoring an outcome to the client.

1. d.

false

servers and mainframes may have centralized databases

false

An information stockroom is a social database that is intended for inquiry and investigation as opposed to for exchange 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.