ISYS 2263 Exam 2 Quizzes

____ are important because they help to ensure data integrity

constraints

The ____ model is the end users' view of the data environment.

external

A ____ is a collection of related records.

file

The number of occurrences of an expression is determined using the ____ function in a form or report.

COUNT

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.

Expression Builder

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters.

Like

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces.

Like "704*"

A criterion may be negated by using the ____ logical operator.

Not

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view

Report Header Section

Which of the following is true of business rules?

They can serve as a communication tool between the users and designers

A(n) ____ might be written by a programmer or it might be created through a DBMS utility program

application program

The database structure in a DBMS is stored as a ____.

collection of files

A(n) ____ model represents a global view of the database as viewed by the entire organization.

conceptual

The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

database system

A noun in a business rule translates to a(n) ____ in the data model.

entity

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

entity relationship

Accurate, relevant, and timely information is the key to ____.

good decision making

One of the limitations of the ____ model is that there is a lack of standards.

hieracrchical

____ is the body of information and facts about a specific subject.

knowledge

A workgroup database is a(n)____ database.

mutliuser

In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

network

____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.

performance tuning

End-user data is ____.

raw facts of interest to the end-user

A verb associating two nouns in a business rule translates to a(n) ____ in the data model.

relationship

A(n) ____ is bidirectional.

relationship

____ data are the result of formatting to facilitate storage, use and generation of information.

structured