Test 1 For Databasing

Front 1

What is the most common classification applied to a DBMS

Back 1

expected type and extent of use

Front 2

Wider access to well-managed data promotes an ________ view of the organizations operations and a clearer view of the big picture.

Back 2

integrated

Front 3

A _____ focuses primarily on storing data used to generate tactical or strategic decisions.

Back 3

Data Warehouse

Front 4

_____ are the people who use applications programs to run the organization's daily operations

Back 4

End Users

Front 5

All fields for a specific entity can be grouped together as a ______.

Back 5

Record

Front 6

Data processing specialists are in existence because of ______.

Back 6

the need to track data and produce reports

Front 7

A _______ allows the user to specify what must be done without specifying how it must be done.

Back 7

procedural language

Front 8

The basic building blocks of all data models are entities, attributes, relationships, and ______.

Back 8

Constraints

Front 9

The hierarchical database model depicts a set of _____ relationships.

Back 9

one-to-many

Front 10

A _______ is the equivalent of a file system's record type.

Back 10

segment

Front 11

The network database models have ______.

Back 11

an owner/member relationship that promotes database integrity

Front 12

The most widely used conceptual model is the _______ model.

Back 12

ER

Front 13

What model requires the most detail in its internal model?

Back 13

Network

Front 14

THe key's role is based on a concept known as ________.

Back 14

determination

Front 15

A superkey is any key that uniquely identifies each ________.

Back 15

row

Front 16

Within a table, the primary key must be unique so that it will identify each row. When this is the case, the table is said to exhibit ________ integrity.

Back 16

Entity

Front 17

A ________ key is defined as a key that is used strictly for data retrieval purposes.

Back 17

secondary

Front 18

A superkey that does not contain a subset of attributes that is itself a superkey is called a ___________.

Back 18

Candidate key