1) One application of data warehouses is:
A) shipping of information.
B) order processing.
C) decision support.
D) file updating. - Answers C
) Older systems that often contain data of poor quality are called ________ systems.
A) controlled
B) legacy
C) database
D) mainframe - Answers B
A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly - Answers A
Which of the following types of data can be stored in a database?
A) Voice
B) Letters
C) Numbers
D) All of the above - Answers D
Data processed in a way that increases a user's knowledge is:
A) text.
B) graphics
C) information.
D) hyperlink. - Answers C
Data that describe the properties of other data are:
A) relationships.
B) logical.
C) physical.
D) none of the above. - Answers D
All of the following are properties of metadata EXCEPT:
A) data definitions.
B) processing logic.
C) rules or constraints.
D) data structures. - Answers B
One disadvantage of file processing systems is:
A) reduced data duplication.
B) program-data independence.
C) limited data sharing.
D) enforcement of integrity constraints - Answers C
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. - Answers A
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. - Answers B
) 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 - Answers 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. - Answers 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. - Answers D
________ 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 - Answers 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 - Answers C
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. - Answers D
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 - Answers C
) ________ 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 - Answers B
With the database approach, data descriptions are stored in a central location known as a(n):
A) server.
B) mainframe.
C) PC.
D) repository. - Answers D
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 - Answers A
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. - Answers C
Which organizational function should set database standards?
A) Management
B) Application development