Chapter 1
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. A) 80 percent B) 60 percent C) 40 percent D) 25 percent
A) 80 Percent
A rule that CANNOT be violated by database users is called a: A) Constraint B) View C) Password D) Program
A) Constraint
Which organizational function should set database standards? A) Database Administration B) Management C) Application Development D) Technical Service
A) Database Administration
The need for consensus on data definitions is an example of which type of risk in the database environment? A) Organizational conflict B) Specialized personnel needs C) Conversion costs D) Legacy systems
A) Organizational conflict
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): A) Repository B) Index C) Data Warehouse D) Database Management System
A) Repository
A knowledge base of information or facts about an enterprise is called a(n): A) Repository. B) Systems information unit. C) Database process. D) Enterprise information system.
A) Repository
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A) User view B) Enterprise view C) User snapshot D) Reporting document
A) User view
A user view is: A) What a user sees when he or she looks out the window B) A logical description of some portion of the database C) A procedure stored on the server. D) A table or set of tables.
B) A logical description of some portion of the database
A graphical system used to capture the nature and relationships among data is called a(n): A) Relational database B) Data model C) Hypertext graphic D) XML data model
B) Data model
Specifying how data from a logical schema are stored in secondary memory is part of the: A) Analysis B) Design C) Implementation D) Maintenance
B) Design
A database is an organized collection of ________ related data. A) Badly B) Logically C) Physically D) Loosely
B) Logically
All of the following are primary purposes of a database management system (DBMS) EXCEPT: A) Updating data B) Providing an integrated development environment. C) Creating data D) Storing data
B) Providing an integrated development environment
________ are established between entities in a well-structured database so that the desired information can be retrieved. A) Ties B) Relationships C) Lines D) Entities
B) Relationships
________ is a tool even non-programmers can use to access information from a database. A) Data manipulation query language B) Structured query language C) ODBC D) ASP
B) Structured Query Language
The traditional methodology used to develop, maintain, and replace information systems is called the: A) Enterprise Resource Model B) Systems Development Life Cycle C) Systems Deployment Life Cycle D) Unified Model
B) Systems Development Life Cycle
The period that can be considered a "proof of concept" time was the: A) 1990s. B) 1950s. C) 1960s. D) 1970s.
C) 1960s
E. F. Codd developed the relational model in the: A) 1990s B) 1980s C) 1970s D) 1960s
C) 1970s
In a file processing environment, descriptions for data and the logic for accessing the data are built into: A) Fields B) Database descriptors C) Application programs D) Records
C) Application programs
Database management involves all of the following EXCEPT: A) Managing data B) Collecting data C) Design web pages D) Organizing data
C) Design web pages
Database development begins with ________, which establishes the range and general contents of organizational databases. A) Database design B) Departmental data modeling C) Enterprise data modeling D) Cross-functional analysis
C) Enterprise data modeling
Program-data dependence is caused by: A) Data descriptions being written into programming code. B) Data descriptions being stored on a server. C) File descriptions being stored in each database application. D) Data cohabiting with programs
C) File descriptions being stored in each database application
Which of the following is NOT an advantage of database systems? A) Reduced program maintenance B) Program-data independence C) Redundant data D) Better data quality
C) Redundant data
A departmental multi-tiered client/server database is stored on a central device called a: A) Remote PC B) Network C) Server D) Client
C) Server
A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): A) Attribute. B) Relationship. C) Object. D) Entity.
D) Entity
The three-schema approach includes which of the following schemas? A) Cross-functional B) Dissecting C) Logical D) Internal
D) Internal
A constraint is a rule in a database system that can be violated by users. TRUE/FALSE
FALSE
A user view is how the user sees the data when it is produced. TRUE/FALSE
FALSE
All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle. TRUE/FALSE
FALSE
An enterprise data model describes the scope of data for only one information system. TRUE/FALSE
FALSE
Data redundancy is used to establish relationships between data but is never used to improve database performance. TRUE/FALSE
FALSE
Database development begins with the design of the database. TRUE/FALSE
FALSE
Database development projects are never done in a bottom-up fashion. TRUE/FALSE
FALSE
Databases were developed as the first application of computers to data processing. TRUE/FALSE
FALSE
In multi-tier database architectures, little functionality needs to be programmed into the client application. TRUE/FALSE
FALSE
Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance. TRUE/FALSE
FALSE
Repositories are always used in file processing systems. TRUE/FALSE
FALSE
Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications. TRUE/FALSE
FALSE
The data that you are interested in capturing about an entity is called an instance. TRUE/FALSE
FALSE
The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle. TRUE/FALSE
FALSE
The steps of the systems development life cycle can only be viewed as a linear process. TRUE/FALSE
FALSE
The term legacy system refers to a newly installed database management system. TRUE/FALSE
FALSE
Visual programming tools such as Visual Basic have made prototyping more difficult. TRUE/FALSE
FALSE
Determining the structure of data and the relationships between data elements either right before or at the time of use of the data is called: A) Schema on write B) Tables on write C) On demand paging D) Caching
Schema on write
A person is an example of an entity. TRUE/FALSE
TRUE
A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. TRUE/FALSE
TRUE
Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle. TRUE/FALSE
TRUE
Database architects establish standards for data in business units. TRUE/FALSE
TRUE
Database maintenance is typically the longest step of the database development process. TRUE/FALSE
TRUE
Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program. TRUE/FALSE
TRUE
File processing systems have been replaced by database systems in most critical business applications today. TRUE/FALSE
TRUE
In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. TRUE/FALSE
TRUE
Information is processed data. TRUE/FALSE
TRUE
Multi-tier client/server database applications contain a business logic layer. TRUE/FALSE
TRUE
One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer. TRUE/FALSE
TRUE
The data repository assists database administrators in enforcing standards. TRUE/FALSE
TRUE
The repository is populated during the analysis phase of the systems development life cycle. TRUE/FALSE
TRUE
The user interface includes languages, menus, and other facilities by which users interact with various system components. TRUE/FALSE
TRUE
