MIS 183 Chapter 1

) 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.

A

A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A

Organizing the database in computer disk storage is done in the ________ phase. A) design B) maintenance C) analysis D) implementation

A

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.

A

The three-schema approach includes which of the following schemas? A) Internal B) Logical C) Cross-functional D) Dissecting

A

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

A

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

A

________ 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

A

) Older systems that often contain data of poor quality are called ________ systems. A) controlled B) legacy C) database D) mainframe

B

) The period that can be considered a "proof of concept" time was the: A) 1950s. B) 1960s. C) 1970s. D) 1990s.

B

) ________ 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

B

A data warehouse derives its data from: A) on-line transactions. B) various operational data sources. C) reports. D) a datamart.

B

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.

B

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.

B

A rule that CANNOT be violated by database users is called a: A) password. B) constraint. C) program. D) view.

B

A workgroup database is stored on a central device called a(n): A) client. B) server. C) remote PC. D) network.

B

All of the following are properties of metadata EXCEPT: A) data definitions. B) processing logic. C) rules or constraints. D) data structures.

B

E. F. Codd developed the relational model in the: A) 1960s. B) 1970s. C) 1980s. D) 1990s.

B

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.

B

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.

B

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

B

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

B

________ 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

B

) 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

C

1) One application of data warehouses is: A) shipping of information. B) order processing. C) decision support. D) file updating.

C

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.

C

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.

C

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

C

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.

C

Data processed in a way that increases a user's knowledge is: A) text. B) graphics C) information. D) hyperlink.

C

One disadvantage of file processing systems is: A) reduced data duplication. B) program-data independence. C) limited data sharing. D) enforcement of integrity constraints

C

One of the most popular RAD methods is: A) automated design. B) structured walkthrough. C) prototyping. D) crafting.

C

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

C

The SDLC phase in which the detailed conceptual data model is created is the ________ phase. A) planning B) design C) analysis D) implementation

C

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

C

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

C

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

C

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

C

________ 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

C

) 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

D

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.

D

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.

D

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.

D

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.

D

Data that describe the properties of other data are: A) relationships. B) logical. C) physical. D) none of the above.

D

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

D

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.

D

The SDLC phase in which database processing programs are created is the ________ phase. A) planning B) design C) analysis D) implementation

D

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.

D

Which of the following types of data can be stored in a database? A) Voice B) Letters C) Numbers D) All of the above

D

Which organizational function should set database standards? A) Management B) Application development C) Technical services D) None of the above

D

With the database approach, data descriptions are stored in a central location known as a(n): A) server. B) mainframe. C) PC. D) repository.

D