Deck 7: Databases and Data Warehouses

Question 1

Once the data warehouse is in operation,much of the ETL activity can be automated.

Answer 1

True

Question 2

A schema describes the structure of the database being designed: the names and types of fields in each record type and the general relationships among different sets of records or files.

Answer 2

True

Question 3

Usually,a table in a relational database must have a primary key,and most relational DBMSs enforce this rule.

Answer 3

True

Question 4

The larger the data warehouse,the larger the storage capacity,the greater the memory,and the greater the processing power of the computers that are needed.

Question 5

The conceptual blueprint of the database is called an entity relationship diagram (ERD).

Question 6

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

Question 7

Multiple characters make up a record.

Question 8

Often,the traditional file approach to storing data leads to low ____.

A) data readability
B) data flexibility
C) data integrity
D) data capacity

Question 9

The very fact that manipulation of the data requires a programmer is probably the greatest disadvantage of the ____.

A) information file approach
B) file approach
C) database approach
D) indexed file approach

Question 10

Object-oriented databases (ODBs)do not store records,but data objects,which is an advantage for quick updates of data sets and the relationships among them.

Question 11

A database itself is a collection of several related files,but DBMSs do all the work-structuring files,storing data,and linking records.

Question 12

Data is accessed in a database by sending messages called "protocols," which request data from specific records and/or fields and direct the computer to display the results.

Question 13

There are two overall approaches to maintaining data: the traditional file approach-which has no mechanism for tagging,retrieving,and manipulating data-and the ____,which does have this mechanism.

A) database approach
B) data approach
C) datafile approach
D) indexed file approach

Question 14

To retrieve records from a relational database,or to sort them,you must use a key.

Question 15

There are two phases involved in building a data warehouse from transactional data: extraction and transforming.

Question 16

Sometimes a key is composed of several records so that their combination provides a unique key.

Question 17

From a technical point of view,online databases that are used with Web browsers are different from other databases.

Question 18

Inaccuracies hurt data integrity.

Question 19

The impact of database technology on business can be easily overstated.

Question 20

One of the most useful manipulations of object-oriented databases (ODBs)is the creation of a new table from two or more other tables.

Question 21

Databases are stored on and processed from ____ storage devices,such as magnetic disks or DVDs.

A) internal access
B) sequential access
C) direct access
D) main access

Question 22

Many organizations have found that if they accumulate ____,they can use it for important management decisions,such as researching market trends or tracking down fraud.

A) transaction indexes
B) field indexes
C) field tables
D) transaction data

Question 23

A collection of related records,such as all the records of a college's students,is called a(n)____.

A) field
B) character
C) item
D) file

Question 24

A ____ can be maintained,for instance,for professors and students in a college database.

A) one-to-many relationship
B) foreign relationship
C) composite relationship
D) many-to-many relationship

Question 25

If ____ need to be used as one large data warehouse,special software tools can unify them and make them appear as one large data warehouse.

A) data marts
B) data carts
C) information marts
D) information repositories

Question 26

____ do not replace transactional databases,which are updated with daily transactions such as sales,billing,cash receipts,and returns.

A) Data houses
B) Data warehouses
C) Data boxes
D) Relational databases

Question 27

In the database approach,data pieces are organized about ____.

A) indexes
B) characters
C) programs
D) entities

Question 28

To design a(n)____,you need a clear idea of the different entities and how they relate.

A) relational database
B) file database
C) model database
D) object database

Question 29

Many ____ also allow a builder to positively indicate when a field is not unique,meaning that the value in that field might be the same for more than one record.

A) languages
B) DBMSs
C) models
D) structures

Question 30

____ should first be done to decide which data should be collected and how it should be organized.

A) Report modeling
B) Data structuring
C) Object structuring
D) Data modeling

Question 31

While a transactional database contains current data,which is disposed of after some time,the data in ____ is accumulated and might reflect many years of business activities.

A) data warehouses
B) data carts
C) information bases
D) information repositories

Question 32

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

A) database relationship
B) database model
C) database list
D) database catalog

Question 33

To link records from one table with records of another table,the tables must have at least one field in common,and that field must be a ____ field for one of the tables.

A) composite key
B) main key
C) foreign key
D) primary key

Question 34

When building a new database,users must first build a schema (from the Greek word for "____").

A) plan
B) job
C) task
D) work

Question 35

A(n)____ is unique if the value (content)in that field appears only in one record.

A) entity
B) key
C) object
D) item

Question 36

All relationships and the various needs for ____ must be taken into account when designing the database.

A) enquiries
B) programs
C) communications
D) reports

Question 37

A(n)____ is created "on the fly" as a result of a query and exists only for the duration the user wishes to view it or to create a paper report from it.

A) join table
B) two-way table
C) object table
D) entity table

Question 38

Effective ____ and design of each database involves the creation of a conceptual blueprint of the database.

A) file modeling
B) file structuring
C) data modeling
D) data relating

Question 39

The combined storage of both data and the procedures that manipulate them is referred to as ____.

A) compression
B) packaging
C) encapsulation
D) zipping

Question 40

A ____ is the field by which records in a table are uniquely identified.

A) secondary key
B) composite key
C) primary key
D) main key

Question 41

While a database itself is a collection of several related files,the program used to build databases,populate them with data,and manipulate the data is called a(n)____________________.

Question 42

A(n)____________________ is any object about which an organization chooses to collect data.

Question 43

A(n)____________________ creates a temporary table that is a subset of the original table or tables.

Question 44

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.

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

Question 45

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 ____________________.

Question 46

In the ____ phase of transferring data from a transactional database to a data warehouse,specialists "cleanse" the data and modify it into a form that allows insertion into the data warehouse.

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

Question 47

A(n)____________________ is one piece of information about an entity,such as the last name or first name of a student,or the student's street address.

Question 48

For some business needs you must use a(n)____________________,a combination of two or more fields that together serve as a primary key,because it is impractical to use a single field as a primary key.

Question 49

Because of capacity needs,organizations often choose ____ to store and manage data warehouses.

A) midrange servers
B) high speed networks
C) mainframe computers with multiple CPUs
D) workstations

Question 50

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.

Question 51

____________________ has become the query language of choice for many developers of relational DBMSs.

Question 52

When management decides to build a ____,the IT staff must carefully consider the hardware,software,and data involved in the effort.

A) network
B) data warehouse
C) database network
D) data house

Question 53

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

Question 54

The ability to limit users' views to only specific columns or records gives the ____________________ another advantage: the ability to implement security measures.

Question 55

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

Question 56

To uncover the valuable information contained in their data,organizations must use software that can effectively "____" data warehouses.

A) house
B) cement
C) merge
D) mine

Question 57

The designers of data warehouses must keep in mind ____: the ability of the data warehouse to grow as the amount of the data and the processing needs grow.

A) flexibility
B) reliability
C) capacity
D) scalability

Question 58

The inclusion of foreign keys to create join tables might cause considerable ____________________.

Question 59

The relational model consists of ____________________.

Question 60

The ability in object-oriented structures to create a new object automatically by replicating all or some of the characteristics of a previously developed object is called ____________________.

Question 61

Explain the impact of databases on businesses.

Question 62

The only way for organizations to conduct some Web-based businesses is to give people outside the organizations access to their ____________________.

Question 63

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

Question 64

Discuss the security issues concerning databases.

Question 65

Organizations often organize their data warehouse as a collection of ____________________,smaller collections of data that focus on a particular subject or department.

Question 66

What are the main features of maintenance of a relational database?

Question 67

In the ____________________ phase of transferring data from a transactional database to a data warehouse,the specialists transfer transformed files to the data warehouse.

Question 68

What are the advantages to integrating SQL in a DBMS?

Question 69

Unlike ____________________,transactional databases are usually not suitable for business analysis because they contain only current,not historical,data.

Question 70

What does metadata include?