Chapter 1 Quiz

Which of the following is NOT an advantage of database systems? Better data quality Reduced program maintenance Program-data independence Redundant data

Redundant data

________ are established between entities in a data model in order to depict how they interact with each other. Relationships Ties Lines Entities

Relationships

________ is a tool even non-programmers can use to access relevant and desired information from a database. ASP.NET Data manipulation query language ODBC Structured query language

Structured query language

In a file processing environment, descriptions for both the data and the logic for accessing the data are built into: fields. application programs. SQL query. database descriptors.

application programs

A rule that CANNOT be violated by database users, and that helps to ensure data quality, is called a: password. program. constraint. syntax rule.

constraint

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. graphic user interface (GUI).

data model

A person, place, object, event, or concept about which the organization wishes model for a database is called a(n): A. relationship. B. attribute. C. object. D. entity.

entity

Program-data dependence is caused by: A. data depending on the programs that use them. B. file descriptions being stored in each database application. C. data descriptions being stored on a server. D. programs depending on the data they use.

file descriptions being stored in each database application

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

logically

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

processing logic

Relational databases establish the relationships between entities by means of common fields (keys) included in a file (or table) called a(n): A. relation. B. association. C. relationship. D. entity.

relation

With the database approach, data descriptions are stored in a central location known as a: server. mainframe. database. repository.

repository

Because applications are often developed independently in file processing systems: A. data can always be shared with others. B. the data is always non-redundant. C. there is a large volume of file IO. D. unplanned duplicate data files are the rule rather than the exception.

unplanned duplicate data files are the rule rather than the exception

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. A. enterprise view B. user snapshot C. reporting document D. user view

user view