1 whole sheet of paper.
Test I. Multiple choices.
1. This database model which is the best suited for structured, routine types of transaction processing is the:
A) Hierarchical structure.
B) Network structure.
C) Object-oriented structure.
D) Relational structure.
2. Some of the database models described in your text require that relationships be specified in advance, thus not supporting ad hoc requests for information. The database structure that does support ad hoc requests is which of the following?
A) Hierarchical structure.
B) Network structure.
C) Relational structure.
D) Object-oriented structure.
3. The multidimensional structure is a variation of the _______________________ database structure.
A) Hierarchical structure.
B) Network structure.
C) Object-oriented structure.
D) Relational structure.
4. This database model consists of data values describing the attributes of an entity, and the operations that can be performed upon the data:
A) Hierarchical structure.
B) Network structure.
C) Object-oriented structure.
D) Relational structure.
5. The logical structure of information in a database is contained in the
A) Data dictionary.
B) Data manipulation subsystem.
C) Data administration subsystem.
D) Data definition subsystem.
6. A graphic method of representing entity classes and their relationships is a(n):
A) Query-by-example tool.
B) Entity-relationship diagram.
C) Intersection relation diagram.
D) Flowchart.
7. The concept of data resource management involves the management of an organization's:
A) Data resources and its people.
B) Data resources and its information technology.
C) Data resources and its information systems functions.
D) Data resources.
8. When employees of a company use online data banks, either those that are free or those available through subscription fees only, they are using which type of database?
A) Common databases.
B) Distributed databases.
C) External databases.
D) Local databases.
9. Which of the following is an example of a use of data mining?
A) Profile customers with more accuracy.
B) Finding root causes to quantity data.
C) Encouraging customer attrition.
D) Discouraging customer cross-selling and profiling.
10. The Emerson and Sanofi real world case illustrated all but which of the following?
A) Any organization can have problems ensuring the accuracy of customer data.
B) Getting data perfect in every application is essential to a company's profitability.
C) Data quality is an ongoing process; a company can't quit after the first task.
D) Data stewards need to be politically astute and good at conflict resolution.
Test II. True or False. Justify your answer.
In any information system, data resources must be organized and structured in some logical manner so that they can be managed effectively, retrieved quickly, and processed effectively.
2 Your text outlines a conceptual view of how data are organized in information systems. In this concept, data can be logically organized into bits, fields, records, files, and databases.
3 According to your text, data may be logically organized into characters, fields, records, files, and databases. Related fields of data are grouped to form a record. Thus, a record represents a collection of attributes that are used to describe an entity.
4 According to your text, data may be logically organized into characters, fields, records, files, and databases. A file represents a group of related records. Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file.
5 Your text discusses a number of database structures. In a hierarchical data structure, each root record may have many associated records at the next level down in the hierarchy, and there may be many additional subordinate levels.
6 Your text describes a number of logical data structures, or models. One of these models is the relational database model. This model is normally more difficult for programmers to work with and is harder to maintain than the hierarchical and network models.
7 Your text discusses a number of database structures. The multidimensional database structure has become a popular database structure for analytical databases that support online analytical processing applications, where fast answers to complex queries are expected.
8 Database administrators and other database developers use the data definition language (DDL) in database management to develop and specify the data contents, relationships, and structure of a database, and to modify these database specifications when necessary.
9 Logical database design takes a view of the data that describes how data are to be physically stored and accessed on the storage devices of a computer system.
10. A data mart is a giant "superstore" of data warehouses from several companies.
0 Comments