Question 1

_______________________ files are special records of updates to other files, especially master and transaction files. They are used in conjunction with archival files to recover "lost" data.

Accepted Answer

The answer of _______________________ files are special records of updates...

Question 2

To facilitate searching and sorting, a(n) _________ is frequently created for keys.

Accepted Answer

The answer of To facilitate searching and sorting, a(n) _________...

Question 3

_________________________ is a resource that must be controlled and managed!

Accepted Answer

The answer of _________________________ is a resource that must be...

Question 4

_______________________ tools are frequently capable of generating SQL code for the database from a CASE-based database schema

Accepted Answer

The answer of _______________________ tools are frequently capable of generating...

Question 5

A good data model should be _________________________ and adaptable to future needs.

Accepted Answer

The answer of A good data model should be _________________________...

Question 6

A business's ____________________ architecture defines how that business will develop and use both files and databases to store all of the organization's data, the file and database technology to be used, and the administrative structure set up to manage the data resource.

Accepted Answer

The answer of A business's ____________________ architecture defines how that...

Question 7

__________________________________ databases are developed to support day-to-day operations and business transaction processing for major information systems.

Accepted Answer

The answer of __________________________________ databases are developed to support day-to-day...

Question 8

Many information systems shops hesitate to give end-users access to operational databases for queries and reports. The volume of unscheduled reports and queries could overload the computers and hamper business operations that the databases were intended to support. That is why
___________________________________ are developed, possibly on separate computers to provide for end-users reports and queries.

Accepted Answer

The answer of Many information systems shops hesitate to give...

Question 9

___________________________ is the term used to describe the use of query tools and decision support tools used to generate reports and analyses off of data warehouses.

Accepted Answer

The answer of ___________________________ is the term used to describe...

Question 10

A(n) _______________________________________ is responsible for the data planning, definition, architecture, and management.

Accepted Answer

The answer of A(n) _______________________________________ is responsible for the data...

Question 11

One or more ____________________________________ are responsible for the database technology,database design and construction consultation, security, backup and recovery, and performance tuning.

Accepted Answer

The answer of One or more ____________________________________ are responsible for...

Question 12

____________________________________________ refers to the database technology including the database engine, database utilities, database CASE tools for analysis and design, and database application development tools.

Accepted Answer

The answer of ____________________________________________ refers to the database technology including...

Question 13

A(n) ______________________________________________________ is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

Accepted Answer

The answer of A(n) ______________________________________________________ is specialized computer software available...

Question 14

A(n) _____________________________ is used by the DBMS to physically establish those record types, fields, and structural relationships. Additionally, the DDL defines views of the database.

Accepted Answer

The answer of A(n) _____________________________ is used by the DBMS...

Question 15

The ______________________________ is able to specify different views of a database.

Accepted Answer

The answer of The ______________________________ is able to specify different...

Question 16

_________________________________ is the data about the data, such as record and field definitions, synonyms, data relationships, validation rules, help messages, etc.

Accepted Answer

The answer of _________________________________ is the data about the data,...

Question 17

A(n) __________________________________ is used to create, read, update, and delete records in the database and to navigate between different records and types of records.

Accepted Answer

The answer of A(n) __________________________________ is used to create, read,...

Question 18

In general, the data manipulation language (DML) is very flexible in that it may be used by itself to create, read, update, and delete records; or its commands may be "called" from a separate host __________________.

Accepted Answer

The answer of In general, the data manipulation language (DML)...

Question 19

_________________________________ implement data in a series of two-dimensional tables that are "related" to one another via foreign keys. Each table consists of named columns (which are fields or attributes) and any number of unnamed rows (which correspond to records).

Accepted Answer

The answer of _________________________________ implement data in a series of...

Question 20

The physical, relational database implementation of the data model is known as the  ________________ .

Accepted Answer

The answer of The physical, relational database implementation of the...

Quiz 14: Database Design