Chapter 5
- Your text describes several major types of databases that may be found in computer-using organizations. Operational databases are described as databases that store detailed data needed to support the business processes and operations of the business enterprise. A transaction processing database is one type of operational database. A) True B) False
- Which statement most accurately describes an operational database?
A) Store detailed data needed to support the operations of the entire organization.
B) Store data and information extracted from selected operational and external databases.
C) Store data from current and previous years that has been extracted from the various operational and management databases of an organization.
D) Are databases of local work groups and departments?
- Why do organizations and their managers need to practice data resource management?
A) Data is either created or accessed with each online mouse click, generating heavy demand on data storage while also driving the need to analyze every bit of data extracted for competitive advantage.
B) Organizations require quantity data to be successful and to accomplish that goal, fresh data needs to be created frequently.
C) Organizations build warehouses to consolidate software tools for data management, requiring the application of information systems technologies to be effective.
D) Organizations and managers need not practice data resource management.
- A DBMS reduces the dependence on information from periodic reports. This is because immediate responses are available by making use of a(n):
A) Database administrator. B) Data dictionary. C) Query language. D) Report generator.
- Which one of the following statements is false regarding the data dictionary?
A) The data analyst normally maintains the data dictionary.
B) Changing the data dictionary can automatically modify data elements in the database itself, if it is an active data dictionary.
C) The data dictionary contains the name and description of each data element, as well as information about the relationships among data elements.
D) The data dictionary is a tool used by the database administrator as well as the casual users.
- Data planning does not include which of the following?
A) The responsibility for developing overall data architecture for the firm's data resources that ties in with the firm's processes of its business units.
B) The responsibility for developing overall data architecture for the firm's data resources that ties in with the firm's strategic mission and plans.
C) The responsibility for developing overall data architecture for the firm's data resources that ties in with the firm's objectives.
D) Data planning include all of the above.
- ________ is the main software package that supports a database management approach.
A) Database Management System B) Database Maintenance System
C) Database D) Data Warehouse
- In the data planning and modeling process described in your text:
A) Database development starts with a bottom-up data planning process.
B) Subject area databases are consolidated to form the enterprise model.
C) User views are generated by identifying the key data elements in the subject area databases, which are needed to perform specific business activities.
D) The enterprise model is mapped directly into the physical database design.
- “An integrated collection of all of the data about customers’ is an example of ________.
A) Character B) Field C) Database D) File
- “The names, addresses, and account balances of all of customers” is an example of ___________.
A) Character B) Field C) Record D) File
- “A customer’s name, addresses, and account balance” is an example of ________.
A) Character B) Field C) Record D) File
- _______________ are the databases that support the major business processes of an organization.
A) Distributed B) Operational C) Hypermedia D) Oracle
- In a __________________, records are organized as cubes within cubes in a database.
A) Hierarchical B) Network C) Multidimensional D) Relational
- Hierarchical database structures easily allow end users to quickly receive information in response to ad hoc requests. A) True B) False
- Today's business enterprises can survive and succeed without data about their internal operations and external environment. A) True B) False
- According to your text, data may be logically organized into characters, fields, records, files, and databases. Of these, the most basic logical data element is a field, which consists of a single alphabetic, numeric, or other symbol. A) True B) False
- According to your text, in the traditional file processing approach, each business application was designed to use one and only one specialized data file containing only specific types of data records. A) True B) False
- Database management involves the use of Personal Information Management (PIM) software to control how databases are created, interrogated, and maintained to provide information needed by an organization and its end users. A) True B) False
- Within the context of database management systems, a query generator is a feature that allows an end user to quickly specify a report format for the display of information retrieved from a database. A) True B) False
- In many companies, database administrators and database design analysts work with end users ad systems analysts to model business processes and the data they require. They perform these tasks in order to develop and manage large corporate databases to support the business processes and their data needs. A) True B) False.
0 comments:
Post a Comment