Exam Ch.1

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

80 percent

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

All of the above

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

Redundant data

________ 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

Relationships

________ 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

Structured query language

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.

data model.

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

decision support.

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.

entity.

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.

file descriptors being stored in each application.

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

information.

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

legacy

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

limited data sharing.

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

logically

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

none of the above

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

processing logic.

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.

providing an integrated development environment

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

relation

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

repository.

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.

unplanned and uncontrolled duplication of data.

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

user view