Chapter 05 Data Resource Management Solution
True / False Questions
1. Variable-length records contain a variable number of fields with fixed field lengths.
True False
2. When independent of any other files related to it, a single table is referred to as a compressed file.
True False
3. Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file.
True False
4. A master file is an integrated collection of logically related data elements.
True False
5. Databases contain data elements that describe both entities and the relationships among entities.
True False
6. Database management packages based on the relational model can link data elements from various tables to provide information to users.
True False
7. The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.
True False
8. A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.
True False
9. Multidimensional databases have become the least popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.
True False
10. The multidimensional database structure is considered one of the key technologies of a new generation of Web-based applications.
True False
11. A database with a network data structure can easily handle a many-to-many data relationship, whereas a hierarchical model cannot.
True False
12. The network model can easily handle ad hoc requests for information, whereas the hierarchical model cannot.
True False
13. All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.
True False
14. Relational databases are more difficult for programmers to work with and more difficult to maintain than the hierarchical and network models.
True False
15. Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs) and other database specialists.
True False
16. An active data dictionary will prevent a data entry program from using a nonstandard definition of a customer record.
True False
17. A data model serves as a logical framework on which to base the physical design of a database.
True False
18. Distributed databases can reside on network servers on the World Wide Web, on corporate intranets, or on corporate extranets.
True False
19. A large database system is often distributed into smaller databases based on some logical relationship between the data and the location of the databases.
True False
20. In a distributed database system, each location gains control of its local data, but loses access to data in other locations.
True False
21. One drawback to the database duplication process is that no changes can ever be made to any database other than the master. Otherwise, local changes will be overwritten during the duplication process.
True False
22. Distributed databases require fewer resources when it comes to computing power and bandwidth.
True False
23. In a traditional file processing approach, each business application is designed to use one or more specialized data files containing only specific types of data records.
True False
24. Having data in independent files makes it easier to provide end users with information for ad hoc requests.
True False
25. In file processing systems, application programs typically contain references to the specific format of the stored data.
True False
26. In file processing systems, it was easy for data elements, such as stock numbers and customer addresses, to be defined differently by different end users and applications.
True False
27. Boolean logic was developed during the latter part of the 1900s.
True False
28. The Internet is nothing more than the world's largest database.
True False
29. DBMS packages play a major role in application development.
True False
Multiple Choice Questions
30. In all information systems, data resources must be organized and structured in some logical manner, so that they can be:
A. Easily accessed
B. Processed efficiently
C. Retrieved quickly
D. All of the choices are correct.
31. From a logical point of view, a(n) ___ is the smallest data element that can be observed and manipulated.
A. character
B. bit
C. attribute
D. byte
32. A record represents a collection of _______________ that describe an entity.
A. characters
B. fields
C. files
D. attributes
33. All the fields used to describe the attributes of an entity are grouped to form a(n) _______________.
A. field
B. record
C. file
D. database
34. A group of related records is a data file, or a _______________.
A. field
B. record
C. table
D. database
35. Variable-length records contain:
A. both a variable number of fields and variable field lengths.
B. both a variable number of fields and fixed field lengths.
C. both a fixed number of fields and variable field lengths.
D. both a fixed number of fields and fixed field lengths.
36. Fixed-length records contain:
A. both a variable number of fields and variable field lengths.
B. both a variable number of fields and fixed field lengths.
C. both a fixed number of fields and variable field lengths.
D. both a fixed number of fields and fixed field lengths.
37. When independent of any other files related to it, a single table is referred to as a(n):
A. Independent file
B. Flat file
C. Hierarchical file
D. Non-variable file
38. A(n) _______________ is an integrated collection of logically related data elements.
A. master file
B. program base
C. database
D. integrated file
39. Databases contain data elements that describe both entities and the _______________ among entities.
A. relationships
B. disparities
C. subsets
D. applications
40. Database management packages based on the _______________ model can link data elements from various tables to provide information to users.
A. object-oriented
B. relational
C. network
D. hierarchical
41. Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.
A. network
B. relational
C. hierarchical
D. object-oriented
42. In a(n) _______________ database structure, all of the relationships among records are one-to-many, because each data element is related to only one element above it.
A. hierarchical
B. relational
C. network
D. object-oriented
43. Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?
A. Hierarchical
B. Network
C. Object-oriented
D. Relational
44. The _______________ model is the most widely used database structure today.
A. network
B. object-oriented
C. relational
D. hierarchical
45. In the relational database model, all data elements within the database are viewed as being stored in the form of simple two-dimensional tables, sometimes referred to as _______________.
A. records
B. rows
C. columns
D. relations
46. The tables in a relational database are flat files which have rows and columns. Each row represents a _______________ in the file.
A. field
B. record
C. file
D. relation
47. The tables in a relational database are flat files which have rows and columns. Each column represents a _______________ in the file.
A. field
B. record
C. file
D. relation
48. The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.
A. link
B. relate
C. project
D. merge
49. Using a relational database, a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table. This is the _______________ operation.
A. join
B. link
C. merge
D. select
50. _______________ is the most commonly used database application for the PC.
A. Oracle 10g
B. Microsoft Access
C. DB2
D. SQL Server
51. _______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.
A. Relational
B. Object-oriented
C. Inter-relational
D. Multidimensional
52. The _______________ database structure is considered one of the key technologies of a new generation of Web-based applications.
A. hierarchical
B. relational
C. object-oriented
D. multidimensional
53. The object-oriented database model supports _______________. That is, new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.
A. inheritance
B. morphing
C. duplication
D. cloning
54. Object technology allows designers to do all of the following except:
A. Develop product designs
B. Replicate product designs and then modify them to create new product designs
C. Save designs as objects in an object-oriented database
D. Substantially reduce the file size of designs
55. Which database structure works effectively with complex data types, such as video clips, audio segments, and other subsets of Web pages, and is considered one of the key technologies of Web-based applications?
A. Hierarchical
B. Network
C. Object-oriented
D. Relational
56. A database with a(n) _______________ data structure can easily handle a many-to-many data relationship.
A. hierarchical
B. network
C. relational
D. object-oriented
57. A database with a(n) _______________ data structure can easily handle ad hoc requests for information.
A. hierarchical
B. network
C. relational
D. object-oriented
58. According to one database pioneer, the future development of databases and data warehouses will depend on _______________.
A. rows
B. columns
C. transaction
D. All of the choices are correct.
59. Large organizations usually place control of enterprise-wide database development in the hands of _______________.
A. Database administrators (DBAs)
B. Automated CASE tools
C. End users
D. All of the choices are correct.
60. According to the text, most data warehouses will run _______________ in a column format.
A. 20 times faster
B. 50 times faster
C. 50 times slower
D. None of the choices are correct.
61. Database administrators and database design analysts work with end users and systems analysts to do all of the following except:
A. Model business processes and the data they require
B. Determine what data definitions should be included in the database
C. Determine what structure or relationships should exist among the data elements
D. Enter live data into the system until it has proven to be reliable
62. _______ are used to model the relationships among the many entities involved in business processes.
A. Entity-relationship diagrams
B. Data-flow diagrams
C. Schema diagrams
D. Subschema diagrams
63. The physical design stage of database development:
A. Develops a model of business processes
B. Translates conceptual models into the data models
C. Determines the data storage structures and access methods
D. Defines the information needs of end users in a business process
64. The _______________ stage of database development translates the conceptual models into the data model of a DBMS.
A. data planning
B. requirements specification
C. conceptual design
D. logical design
65. A _______________ is an overall logical view of the relationships among the data elements in a database.
A. schema
B. subschema
C. logical data model
D. conceptual design
66. A _______________ is an overall logical view of the relationships needed to support specific end-user application programs that will access the database.
A. schema
B. subschema
C. logical data model
D. conceptual design
67. According to the textbook case, the innovation of the open-source product Hadoop is _______________.
A. that it has not been sued by Google
B. that it actually works
C. that it has no proprietary predecessor
D. its algorithms run contrary to contemporary mathematics
68. According to the textbook case, file processing in Hadoop is not halted by hardware failures because _______________.
A. Hadoop is a software product
B. Open-source products are not affected by hardware failures
C. Hadoop is an Internet product and does not need hardware
D. Hadoop keeps three (3) copies of all data
69. Operational databases store the detailed data needed to support the business processes and operations of a company. They are also called _______________.
A. Subject area databases
B. Transaction databases
C. Production databases
D. All of the choices are correct.
70. The primary challenge of a distributed database is:
A. Data accuracy
B. Data transmission speed
C. Storage costs
D. Data security
71. Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?
A. The two terms are interchangeable because the processes work the same way
B. Duplication is the more complicated process because it has to identify one database as a master and prevent changes being made to any database other than the master
C. Replication is the more complicated process because it must find changes in each distributed database and make appropriate changes to make each database identical
D. None of the choices are correct.
72. What type of databases are employees using when they access online data banks, whether those data banks are free or paid for through subscriptions?
A. Common databases
B. Distributed databases
C. External databases
D. Local databases
73. A central source of data that have been cleaned, transformed, and cataloged so that they can be used for business analysis, market research, and decision support is called a _______________.
A. data mart
B. data warehouse
C. transaction processing mart
D. data repository
74. A data warehouse contains data that have been processed in all the following ways except:
A. Separated
B. Cleaned
C. Transformed
D. Cataloged
75. Which of the following is true of data marts?
A. They hold data from many different data warehouses.
B. They are a subset of a data warehouse.
C. They focus on many generalized aspects of a company.
D. None of the choices are correct.
76. Which of the following is true of data in a data warehouse?
A. Data in operational databases is ever changing; data in data warehouses is static
B. Data in operational databases is static; data in data warehouses is ever changing
C. Data in operational databases can be cataloged; data in data warehouses cannot
D. None of the choices are correct.
77. Which of the following is a legitimate use for data mining?
A. Performing "market-basket analysis" to identify new product bundles
B. Profiling customers
C. Finding the root cause of a quality or manufacturing problem
D. All of the choices are correct.
78. All of the following contribute to problems when using a file management approach except:
A. Data redundancy
B. Lack of integration of data
C. Data independence
D. Lack of data integrity
79. Database management involves the use of database management software to control how databases are _______________.
A. created
B. interrogated
C. maintained
D. All of the choices are correct.
80. In mainframe and server computer systems, the database management system controls the _______________ of the databases of computer-using organizations.
A. maintenance
B. development
C. use
D. All of the choices are correct.
81. All of the following are major functions of a database management system except:
A. Creating new databases and database applications
B. Identifying insufficient data processing or storage needs
C. Maintaining the quality of the data in an organization's databases
D. Using the databases of an organization to provide the information needed by its end users
82. Database development involves defining and organizing the _______________ of the data needed to build a database.
A. structure
B. content
C. relationships
D. All of the choices are correct.
83. A DBMS query language is designed to:
A. Support information systems professionals in the development of complex application software
B. Support end users who wish to obtain ad hoc reports
C. Provide efficient batch mode processing of the database
D. Specify the content, relationships, and structure of a database
84. The database maintenance process is accomplished via:
A. Hierarchical database systems that provide flexibility and network databases
B. Transaction processing systems and other end user applications, with the support of the DBMS
C. Graphical query languages correctly phrasing SQL
D. File processing systems with the support of 4GLs
85. The basic form of a SQL query is:
A. SELECT … AND … OR
B. SELECT … WHERE … FROM …
C. SELECT … FROM … WHERE …
D. AND … OR … NOT …
86. Boolean logic deals with three logical operators:
A. AND, OR, and BUT
B. AND, NOT, and BUT
C. OR, BUT, and NOT
D. AND, OR, and NOT
87. Many end users have trouble correctly phrasing database language search queries, so most end-user DBMS packages now offer _______________ methods.
A. speech recognition
B. command line
C. GUI
D. All of the choices are correct.