Question 1

_________________________________ 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 2

Which of the following is the smallest unit of data stored?

Accepted Answer

A)  file 
B)  logical record 
C)  block 
D)  field 
E)  none of these

Question 3

Given the large capacity disks that are now available, database administrators no longer have to be concerned about estimating how much disk capacity is required for a new database.

Accepted Answer

A) True 
 B)False

Question 4

Both triggers and stored procedures are reusable because they are stored with the tables themselves as_____________________.

Accepted Answer

The answer of Both triggers and stored procedures are reusable...

Question 5

The person responsible for the database technology, database design and construction consultation, security, backup and recovery, and performance tuning is known as a(n):

Accepted Answer

A)  data administrator 
B)  database administrator 
C)  system owner 
D)  end-user 
E)  none of these

Question 6

__________________________________ 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 7

Database technology provides superior scalability, meaning that the database and the systems that use it can be grown or expanded to meet the changing needs of an organization.

Accepted Answer

A) True 
 B)False

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

Key integrity for a database means that every table should have a primary key.

Accepted Answer

A) True 
 B)False

Question 10

Triggers are programs embedded within a table that can be called from an application program.

Accepted Answer

A) True 
 B)False

Question 11

The number of logical records included in a single read or write operation from the computer's perspective is known as the:

Accepted Answer

A)  length factor 
B)  transaction factor 
C)  blocking factor 
D)  referential factor 
E)  none of these

Question 12

____________________________ integrity means that appropriate controls must be designed to ensure that no field takes on a value that is outside the range of legal values.

Accepted Answer

The answer of ____________________________ integrity means that appropriate controls must...

Question 13

A blocking factor allows different records in the same file to have different lengths.

Accepted Answer

A) True 
 B)False

Question 14

Data distribution analysis establishes which business locations need access to which logical data entities and attributes.

Accepted Answer

A) True 
 B)False

Question 15

Files tend to be built around single applications without regard to other, future applications.

Accepted Answer

A) True 
 B)False

Question 16

A database that stores data extracted from operational databases for the purpose of data mining is called a(n):

Accepted Answer

A)  transactional database 
B)  personal database 
C)  workgroup database 
D)  data warehouse 
E)  distributed database

Question 17

Operational databases and conventional files store data extracted from data warehouses.

Accepted Answer

A) True 
 B)False

Question 18

A data administrator is responsible for the data planning, definition, architecture, and management.

Accepted Answer

A) True 
 B)False

Question 19

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 20

Files or tables that contain records that describe business events are known as:

Accepted Answer

A)  master 
B)  transaction 
C)  document 
D)  archival 
E)  none of these

Exam 14: Database Design

_________________________________ 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).

Which of the following is the smallest unit of data stored?

Given the large capacity disks that are now available, database administrators no longer have to be concerned about estimating how much disk capacity is required for a new database.

Both triggers and stored procedures are reusable because they are stored with the tables themselves as_____________________.

The person responsible for the database technology, database design and construction consultation, security, backup and recovery, and performance tuning is known as a(n) :

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

Database technology provides superior scalability, meaning that the database and the systems that use it can be grown or expanded to meet the changing needs of an organization.

Key integrity for a database means that every table should have a primary key.

Triggers are programs embedded within a table that can be called from an application program.

The number of logical records included in a single read or write operation from the computer's perspective is known as the:

____________________________ integrity means that appropriate controls must be designed to ensure that no field takes on a value that is outside the range of legal values.

A blocking factor allows different records in the same file to have different lengths.

Data distribution analysis establishes which business locations need access to which logical data entities and attributes.

Files tend to be built around single applications without regard to other, future applications.

A database that stores data extracted from operational databases for the purpose of data mining is called a(n) :

Operational databases and conventional files store data extracted from data warehouses.

A data administrator is responsible for the data planning, definition, architecture, and management.

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.

Files or tables that contain records that describe business events are known as: