Question 1

Describe the uses of a composite key with an example.

Accepted Answer

The answer of Describe the uses of a composite key...

Question 2

The smallest piece of data is called a_________ .

Accepted Answer

A) field 
B) record 
C) query 
D) character

Question 3

The _________model uses the object-oriented approach to maintaining records.

Accepted Answer

The answer of The _________model uses the object-oriented approach to...

Question 4

_________are entered to manipulate data,including adding,deleting,and updating data.

Accepted Answer

A) Foreign keys 
B) Primary keys 
C) Queries 
D) Reports

Question 5

If your last and first name,as well as address and other details appear in the files of the department where you work as well as in the payroll file of the Human Resource department,there is duplication of data,or _________.

Accepted Answer

The answer of If your last and first name,as well...

Question 6

The relational database model consists of_________ which are used to contain records.

Accepted Answer

The answer of The relational database model consists of_________ which...

Question 7

A data warehouse is a large,typically relational,database that supports management decision making.

Accepted Answer

A) True 
 B)False

Question 8

Transactional data is copied into a _________,which is a separate data repository.

Accepted Answer

A) data dictionary 
B) data warehouse 
C) database schema 
D) traditional database

Question 9

A _________is the general logical structure in which records are stored within a database and the method used to establish relationships among the records.

Accepted Answer

A) database query 
B) database model 
C) database system 
D) database catalog

Question 10

In the _________phase of transferring data from a transactional database to a data warehouse,the builders create the files from transactional databases and save them on the server that will hold the data warehouse.

Accepted Answer

A) loading 
B) transformation 
C) extraction 
D) injection

Question 11

What are the advantages to integrating SQL in a DBMS?

Accepted Answer

The answer of What are the advantages to integrating SQL...

Question 12

In the_________ phase of data warehousing,specialists compare the data in the data warehouses with the original data to confirm completeness.

Accepted Answer

A) extraction 
B) loading 
C) divisional 
D) transformation

Question 13

The ability to limit users' views to only specific columns or records gives a(n) _________an advantage: the ability to implement security measures.

Accepted Answer

The answer of The ability to limit users' views to...

Question 14

Inaccuracies affect data integrity.

Accepted Answer

A) True 
 B)False

Question 15

The description of each table structure and types of fields become part of a(n)_________ ,which is a repository of information about the data and their organization.

Accepted Answer

The answer of The description of each table structure and...

Question 16

The inclusion of foreign keys to create join tables might cause considerable _________,a complexity that has not diminished the popularity of relational databases.

Accepted Answer

The answer of The inclusion of foreign keys to create...

Question 17

Analyzing an organization's data and identifying the relationships among the data is called_________ .

Accepted Answer

The answer of Analyzing an organization's data and identifying the...

Question 18

A unique key can serve as a(n) _________.

Accepted Answer

The answer of A unique key can serve as a(n)...

Question 19

A join table combines data from two or more tables.

Accepted Answer

A) True 
 B)False

Question 20

When building a new database,users must first build a_________ .

Accepted Answer

A) schema 
B) relationship 
C) model 
D) structure

Exam 7: Databases and Data Warehouses

Describe the uses of a composite key with an example.

The smallest piece of data is called a_________ .

The _________model uses the object-oriented approach to maintaining records.

_________are entered to manipulate data,including adding,deleting,and updating data.

If your last and first name,as well as address and other details appear in the files of the department where you work as well as in the payroll file of the Human Resource department,there is duplication of data,or _________.

The relational database model consists of_________ which are used to contain records.

A data warehouse is a large,typically relational,database that supports management decision making.

Transactional data is copied into a _________,which is a separate data repository.

A _________is the general logical structure in which records are stored within a database and the method used to establish relationships among the records.

In the _________phase of transferring data from a transactional database to a data warehouse,the builders create the files from transactional databases and save them on the server that will hold the data warehouse.

What are the advantages to integrating SQL in a DBMS?

In the_________ phase of data warehousing,specialists compare the data in the data warehouses with the original data to confirm completeness.

The ability to limit users' views to only specific columns or records gives a(n) _________an advantage: the ability to implement security measures.

Inaccuracies affect data integrity.

The description of each table structure and types of fields become part of a(n)_________ ,which is a repository of information about the data and their organization.

The inclusion of foreign keys to create join tables might cause considerable _________,a complexity that has not diminished the popularity of relational databases.

Analyzing an organization's data and identifying the relationships among the data is called_________ .

A unique key can serve as a(n) _________.

A join table combines data from two or more tables.

When building a new database,users must first build a_________ .