Question 1

Most databases created today do not use the hierarchical or network models;these models are generally used with legacy systems that are still operational and must be maintained.

Accepted Answer

A) True 
 B)False

Question 2

At the lowest level,words are entered into database fields/columns,which hold single pieces of data in the database,such as product names or quantities.

Accepted Answer

A) True 
 B)False

Question 3

Web databases allow Web pages to be static Web pages; that is, Web pages in which the appearance or content of the pages change based on the user’s input.

Accepted Answer

A) True 
 B)False

Question 4

Objects stored in an OODBMS can be retrieved using queries,such as with a(n)object query language (OQL)-an object-oriented version of SQL.

Accepted Answer

A) True 
 B)False

Question 5

____ are made up of related records.

Accepted Answer

A) Rows 
B) Fields 
C) Columns 
D) Tables

Question 6

As part of its disaster-recovery plan,some firms maintain a(n)hot site-an alternate location equipped with identical hardware and software that can be used to resume operations quickly in case of a major disaster.

Accepted Answer

A) True 
 B)False

Question 7

In some systems,data integrity is enforced on a per transaction basis.

Accepted Answer

A) True 
 B)False

Question 8

If a field needs to store decimal places,the Long Integer field size can be used.

Accepted Answer

A) True 
 B)False

Question 9

After all the tables in a database application have been created and their primary keys designated,the tables can be related to one another via their primary key so that a primary key for one table can be used to extract data from other tables as needed.

Accepted Answer

A) True 
 B)False

Question 10

With ____,data is stored in single multidimensional database structures (sometimes called data cubes).

Accepted Answer

A) Online Analytical Processing (OLAP) 
B) ROLAP (Relational OLAP) 
C) MOLAP (Multidimensional OLAP) 
D) HOLAP (Hybrid OLAP)

Question 11

With indexed organization,a(n)____________________ is used to keep track of where data is stored.

Accepted Answer

The answer of With indexed organization,a(n)____________________ is used to keep...

Question 12

Individual database tables are often referred to as ____.

Accepted Answer

A) low files 
B) base files 
C) flat files 
D) clear files

Question 13

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

Accepted Answer

The answer of ____________________ usually includes the programs used with...

Question 14

A record is also called a ____.

Accepted Answer

A) field 
B) report 
C) row 
D) table

Question 15

Data definition involves describing the properties of the data that go into each database table,specifically the ____ that make up the database.

Accepted Answer

A) records 
B) rows 
C) fields 
D) characters

Question 16

Case 14-2
The JL Group is a political think tank that is incorporating new media into their analyses.
-The JL Group has gathered data on voting habits.In order to make sure that respondents cannot claim to have voted in more elections than is possible given their age,____ rules can be assigned to the database tables.

Accepted Answer

A) index validation 
B) record validation 
C) DBA validation 
D) dynamic

Question 17

Normalization is usually viewed as a multistep process,from first normal form (1NF)to usually fifth normal form (5NF).

Accepted Answer

A) True 
 B)False

Question 18

In determining the location where specific data is to be stored in a(n)centralized DBMS,factors such as communications cost,response time,storage cost,and security are key considerations.

Accepted Answer

A) True 
 B)False

Question 19

Upgrading the database software and installing patches as needed is a database ____________________ activity.

Accepted Answer

The answer of Upgrading the database software and installing patches...

Question 20

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.

Accepted Answer

A) normalization 
B) cyclic redundancy check 
C) zeroing 
D) zonification

Exam 14: Databases and Database Management Systems

Most databases created today do not use the hierarchical or network models;these models are generally used with legacy systems that are still operational and must be maintained.

At the lowest level,words are entered into database fields/columns,which hold single pieces of data in the database,such as product names or quantities.

Web databases allow Web pages to be static Web pages; that is, Web pages in which the appearance or content of the pages change based on the user’s input.

Objects stored in an OODBMS can be retrieved using queries,such as with a(n)object query language (OQL)-an object-oriented version of SQL.

____ are made up of related records.

As part of its disaster-recovery plan,some firms maintain a(n)hot site-an alternate location equipped with identical hardware and software that can be used to resume operations quickly in case of a major disaster.

In some systems,data integrity is enforced on a per transaction basis.

If a field needs to store decimal places,the Long Integer field size can be used.

After all the tables in a database application have been created and their primary keys designated,the tables can be related to one another via their primary key so that a primary key for one table can be used to extract data from other tables as needed.

With ____,data is stored in single multidimensional database structures (sometimes called data cubes) .

With indexed organization,a(n)____________________ is used to keep track of where data is stored.

Individual database tables are often referred to as ____.

____________________ usually includes the programs used with the database and the programs needed to connect the client and server components of the database system.

A record is also called a ____.

Data definition involves describing the properties of the data that go into each database table,specifically the ____ that make up the database.

Normalization is usually viewed as a multistep process,from first normal form (1NF)to usually fifth normal form (5NF).

In determining the location where specific data is to be stored in a(n)centralized DBMS,factors such as communications cost,response time,storage cost,and security are key considerations.

Upgrading the database software and installing patches as needed is a database ____________________ activity.

The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.