Question 1

Which of the following is a source of internal data?

Accepted Answer

A) Tax records 
B) Sales records 
C) Distribution networks 
D) Economic indicators

Question 2

Which of the following is true of a database?

Accepted Answer

A) Complex requests can be difficult to handle. 
B) More storage space is required. 
C) Programs and data are interdependent. 
D) More information can be generated from the same data.

Question 3

____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

A) optimization 
B) fragmentation 
C) normalization 
D) encapsulation

Question 4

A database ____ is responsible for data storage,manipulation,and retrieval.

Accepted Answer

A) program 
B) index 
C) system 
D) engine

Question 5

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the DBMS.

Accepted Answer

A) True 
 B)False

Question 6

The ____ approach to setting up a distributed DBMS addresses how tables are divided among multiple locations.

Accepted Answer

A) normalization 
B) encapsulation 
C) fragmentation 
D) replication

Question 7

The indexed sequential access method (ISAM)is slow and becomes increasingly useful as the number of records becomes larger.

Accepted Answer

A) True 
 B)False

Question 8

What are the advantages of a data mart over a data warehouse?

Accepted Answer

The answer of What are the advantages of a data...

Question 9

A data ____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Accepted Answer

A) dictionary 
B) mart 
C) mine 
D) warehouse

Question 10

A ____ operation searches data in a table and retrieves records based on certain criteria.

Accepted Answer

A) project 
B) join 
C) find 
D) select

Question 11

One advantage a database has over a flat file system is that more information can be generated from the same data.

Accepted Answer

A) True 
 B)False

Question 12

The data ____ component is used to create and maintain the data dictionary.

Accepted Answer

A) manipulation 
B) application 
C) definition 
D) administration

Question 13

A ____ operation pares down a table by eliminating columns according to certain criteria.

Accepted Answer

A) project 
B) join 
C) find 
D) select

Question 14

The sequential access file structure method is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

Accepted Answer

A) True 
 B)False

Question 15

With the ____________________ distributed DBMS approach,each site stores a copy of the data in the organization's database.

Accepted Answer

The answer of With the ____________________ distributed DBMS approach,each site...

Question 16

A data ____ is usually a smaller version of a data warehouse,used by a single department or function.

Accepted Answer

A) domain 
B) mine 
C) dictionary 
D) mart

Question 17

Disks are sequential access devices,whereas tapes are random access devices.

Accepted Answer

A) True 
 B)False

Question 18

A(n)____________________ is usually a smaller version of a data warehouse,used by a single department or function.

Accepted Answer

The answer of A(n)____________________ is usually a smaller version of...

Question 19

____ is information in its original form.

Accepted Answer

A) Summary data 
B) Raw data 
C) Open data 
D) Metadata

Question 20

List the responsibilities of a database administrator (DBA).

Accepted Answer

The answer of List the responsibilities of a database administrator...

Exam 3: Database Systems,data Warehouses,and Data Marts

Which of the following is a source of internal data?

Which of the following is true of a database?

____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

A database ____ is responsible for data storage,manipulation,and retrieval.

A database engine converts logical requests from users into their physical equivalents by interacting with other components of the DBMS.

The ____ approach to setting up a distributed DBMS addresses how tables are divided among multiple locations.

The indexed sequential access method (ISAM)is slow and becomes increasingly useful as the number of records becomes larger.

What are the advantages of a data mart over a data warehouse?

A data ____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

A ____ operation searches data in a table and retrieves records based on certain criteria.

One advantage a database has over a flat file system is that more information can be generated from the same data.

The data ____ component is used to create and maintain the data dictionary.

A ____ operation pares down a table by eliminating columns according to certain criteria.

The sequential access file structure method is effective when a large number of records are processed less frequently,perhaps on a quarterly or yearly basis.

With the ____________________ distributed DBMS approach,each site stores a copy of the data in the organization's database.

A data ____ is usually a smaller version of a data warehouse,used by a single department or function.

Disks are sequential access devices,whereas tapes are random access devices.

A(n)____________________ is usually a smaller version of a data warehouse,used by a single department or function.

____ is information in its original form.

List the responsibilities of a database administrator (DBA).