Deck 1: The Database Environment and Development Process

Question 1

Relational databases establish the relationships between entities by means of common fields included in a file called a(n)________.

A) entity
B) relationship
C) relation
D) association

Answer 1

C

Question 2

One disadvantage of file processing systems is:

A) reduced data duplication.
B) program-data independence.
C) limited data sharing.
D) enforcement of integrity constraints.

Answer 2

C

Question 3

With the database approach,data descriptions are stored in a central location known as a(n):

A) server.
B) mainframe.
C) PC.
D) repository.

Answer 3

D

Question 4

Data that describe the properties of other data are:

A) relationships.
B) logical.
C) physical.
D) none of the above.

Question 5

A database is an organized collection of ________ related data.

A) logically
B) physically
C) loosely
D) badly

Question 6

Older systems that often contain data of poor quality are called ________ systems.

A) controlled
B) legacy
C) database
D) mainframe

Question 7

________ are established between entities in a well-structured database so that the desired information can be retrieved.

A) Entities
B) Relationships
C) Lines
D) Ties

Question 8

Which of the following is NOT an advantage of database systems?

A) Redundant data
B) Program-data independence
C) Better data quality
D) Reduced program maintenance

Question 9

All of the following are primary purposes of a database management system (DBMS)EXCEPT:

A) creating data.
B) updating data.
C) storing data.
D) providing an integrated development environment.

Question 10

A(n)________ is often developed by identifying a form or report that a user needs on a regular basis.

A) enterprise view
B) reporting document
C) user view
D) user snapshot

Question 11

Program-data dependence is caused by:

A) file descriptors being stored in each application.
B) data descriptions being stored on a server.
C) data descriptions being written into programming code.
D) data cohabiting with programs.

Question 12

________ is a tool even non-programmers can use to access information from a database.

A) ODBC
B) Structured query language
C) ASP
D) Data manipulation query language

Question 13

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.

A) 40 percent
B) 25 percent
C) 60 percent
D) 80 percent

Question 14

Which of the following types of data can be stored in a database?

A) Voice
B) Letters
C) Numbers
D) All of the above

Question 15

Data processed in a way that increases a user's knowledge is:

A) text.
B) graphics
C) information.
D) hyperlink.

Question 16

A person,place,an object ,an event or concept about which the organization wishes to maintain data is called a(n):

A) relationship.
B) object.
C) attribute.
D) entity.

Question 17

A graphical system used to capture the nature and relationships among data is called a(n):

A) logical data model.
B) hypertext graphic.
C) ERD.
D) data model.

Question 18

All of the following are properties of metadata EXCEPT:

A) data definitions.
B) processing logic.
C) rules or constraints.
D) data structures.

Question 19

One application of data warehouses is:

A) shipping of information.
B) order processing.
C) decision support.
D) file updating.

Question 20

Loss of metadata integrity is often a result of:

A) poor design.
B) unplanned and uncontrolled duplication of data.
C) decreased programmer productivity.
D) a large volume of file i/o.

Question 21

A centralized knowledge base of all data definitions,data relationships,screen and report formats,and other system components is called a(n):

A) index.
B) data warehouse.
C) repository.
D) database management system.

Question 22

Databases may be more expensive to maintain than files because of:

A) the need for specialized personnel.
B) the complexity of the database environment.
C) backup and recovery needs.
D) all of the above.

Question 23

The most common source of database failures in organizations is:

A) lack of planning.
B) inadequate budget.
C) inadequate hardware.
D) failure to implement a strong database administration function.

Question 24

A relatively small team of people who collaborate on the same project is called a(n):

A) server group.
B) workgroup.
C) data collaborative.
D) typical arrangement.

Question 25

Which of the following is an integrated decision support database with content derived from various operational databases?

A) Corporate data structure
B) Relational DBMS
C) Data warehouse
D) Client-server system

Question 26

A data warehouse derives its data from:

A) on-line transactions.
B) various operational data sources.
C) reports.
D) a datamart.

Question 27

A knowledge base of information on facts about an enterprise is called a(n):

A) enterprise information system.
B) repository.
C) systems information unit.
D) database process.

Question 28

Which organizational function should set database standards?

A) Management
B) Application development
C) Technical services
D) None of the above

Question 29

In a file processing environment,descriptions for data and the logic for accessing the data is built into:

A) application programs.
B) database descriptors.
C) fields.
D) records.

Question 30

Languages,menus,and other facilities by which users interact with the database are collectively called a(n):

A) client.
B) user interface.
C) icon.
D) development environment.

Question 31

A workgroup database is stored on a central device called a(n):

A) client.
B) server.
C) remote PC.
D) network.

Question 32

A rule that CANNOT be violated by database users is called a:

A) password.
B) constraint.
C) program.
D) view.

Question 33

A user view is:

A) what a user sees when he or she looks out the window.
B) a table or set of tables.
C) a logical description of some portion of the database.
D) a procedure stored on the server.

Question 34

CASE is a class of tools that:

A) assists the database administrator in maintaining a database.
B) provides guidelines for the physical design of a database.
C) provides management reporting tools.
D) automates the design of databases and application programs.

Question 35

Which of the following is software used to create,maintain,and provide controlled access to databases?

A) Network operating system
B) User view
C) Database management system
D) Attribute

Question 36

The need for consensus on data definitions is an example of which type of risk in the database environment?

A) Specialized personnel needs
B) Organizational conflict
C) Conversion costs
D) Legacy systems

Question 37

Which of the following is NOT a cost and/or risk of the database approach?

A) Specialized personnel
B) Cost of conversion
C) Improved responsiveness
D) Organizational conflict

Question 38

The period that can be considered a "proof of concept" time was the:

A) 1950s.
B) 1960s.
C) 1970s.
D) 1990s.

Question 39

E.F.Codd developed the relational model in the:

A) 1960s.
B) 1970s.
C) 1980s.
D) 1990s.

Question 40

Which of the following is NOT an objective that drove the development and evolution of database technology?

A) The need to provide greater independence between programs and data
B) The desire to manage increasing complex data types and structures
C) The desire to require programmers to write all file handling functionality
D) The need to provide ever more powerful platforms for decision support applications

Question 41

________ concentrate on determining the requirements for the database component of an information system.

A) Database analysts
B) Systems analysts
C) Programmers
D) All of the above

Question 42

The SDLC phase in which database processing programs are created is the ________ phase.

A) planning
B) design
C) analysis
D) implementation

Question 43

With the traditional file processing approach,each application shares data files,thus enabling much data sharing.

Question 44

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.

Question 45

Metadata are data that describe the properties of other data.

Question 46

Database development begins with ________,which establishes the range and general contents of organizational databases.

A) database design
B) cross-functional analysis
C) departmental data modeling
D) enterprise data modeling

Question 47

Unplanned duplicate data files are the rule rather than the exception in file processing systems.

Question 48

Organizing the database in computer disk storage is done in the ________ phase.

A) design
B) maintenance
C) analysis
D) implementation

Question 49

One of the most popular RAD methods is:

A) automated design.
B) structured walkthrough.
C) prototyping.
D) crafting.

Question 50

Which of the following will interfere with access to operational databases?

A) Unstructured and unpredictable use of data
B) Predictable use of data
C) Efficient transaction processing systems
D) All of the above

Question 51

An iterative methodology that rapidly repeats the analysis,design,and implementation phases of the SDLC is called:

A) CASE.
B) CAD.
C) RAD.
D) MST.

Question 52

The traditional methodology used to develop,maintain and replace information systems is called the:

A) Enterprise Resource Model
B) Systems Development Life Cycle
C) Unified Model
D) Systems Deployment Life Cycle

Question 53

The SDLC phase in which the detailed conceptual data model is created is the ________ phase.

A) planning
B) design
C) analysis
D) implementation

Question 54

File processing systems have been replaced by database systems in most critical business applications today.

Question 55

In practice,databases today may contain either data or information.

Question 56

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.

A) Programmers
B) Users
C) Systems analysts
D) Database analysts

Question 57

Databases were developed as the first application of computers to data processing.

Question 58

Information is processed data.

Question 59

The SDLC phase in which every data attribute is defined,every category of data are listed and every business relationship between data entities is defined is called the ________ phase.

A) planning
B) design
C) analysis
D) implementation

Question 60

The three-schema approach includes which of the following schemas?

A) Internal
B) Logical
C) Cross-functional
D) Dissecting

Question 61

The failure to implement a strong database administrative function is the most common source of database failures in organizations.

Question 62

A relational database establishes the relationships between entities by means of a common field.

Question 63

A data model is a graphical system used to capture the nature and relationships among data,

Question 64

A database management system is an integrated development environment.

Question 65

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.

Question 66

Many of the disadvantages of file processing systems can also be limitations of databases.

Question 67

The term legacy system refers to a newly installed database management system.

Question 68

A user view is how the user sees the data when it is produced.

Question 69

A well-structured database establishes the entities between relationships in order to derive the desired information.

Question 70

Data redundancy is used to establish relationships between data but is never used to improve database performance.

Question 71

Separation of metadata from application programs that use the data is called data independence.

Question 72

Reduced program maintenance is an advantage of file processing systems.

Question 73

Redundancy increases the risk of inconsistent data.

Question 74

Cost and complexity are just two of the disadvantages of database processing.

Question 75

A constraint is a rule in a database system that can be violated by users.

Question 76

The data that you are interested in capturing about an entity is called an instance.

Question 77

A person is an example of an entity.

Question 78

The data repository assists database administrators in enforcing standards.

Question 79

End users can often retrieve and display data easily with a relational database

Question 80

Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.