Deck 7: Databases and Data Warehouses

Question 1

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 1

True

Question 2

Inaccuracies affect data integrity.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

Database fields are limited to holding text and numbers.

Question 6

Database management systems structure files,store data,and link records.

Question 7

A join table combines data from two or more tables.

Question 8

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 9

A challenge with traditional file storage is _________.

A)low data redundancy
B)high data accuracy
C)high data integrity
D)low data misrepresentation

Question 10

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

Question 11

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)object-oriented approach
C)asymmetric approach
D)indexed file approach

Question 12

The three phases involved in building a data warehouse from transactional data are extraction,transforming,and loading.

Question 13

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

Question 14

In the context of data management, _________refers to all the occurrences sharing the same types of data.

A)metadata
B)entity
C)encapsulation
D)schema

Question 15

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

Question 16

Multiple characters make up a record.

Question 17

The messages sent to access data in a database are called protocols.

Question 18

Data warehouses replace transactional databases.

Question 19

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 20

Much of the extraction,transforming,and loading (ETL) activity involved in data transfer can be automated.

Question 21

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 22

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)traditional databases
C)database models
D)data dictionaries

Question 23

In relational database,a record or row is called a_________ .

A)tuple
B)attribute
C)table
D)relation

Question 24

_________helps the users know what they can find and analyze in the data warehouse.

A)A foreign key
B)Encapsulation
C)A composite key
D)Metadata

Question 25

A(n)_________is the field by which records in a table are uniquely identified.

A)database model
B)query
C)primary key
D)object

Question 26

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

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

Question 27

_________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 28

A repeated field that links records between two tables,is a primary key in one table,and a(n) _________in the other field.

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

Question 29

Online databases that are used with web browsers_________ .

A)are no different from other databases
B)do not require an interface
C)do not use queries
D)can directly understand user input

Question 30

The conceptual blueprint of a database is called a(n)_________ .

A)structured query language (SQL)
B)uniform resource diagram (URD)
C)entity relationship diagram (ERD)
D)unified modeling language (UML)

Question 31

The combined storage of both data and the procedures that manipulate the data within an object is referred to as
_____.

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

Question 32

A(n)_________ includes a description of a database's structure,the names and sizes of the fields,and details such as which field is a primary key.

A)entity
B)schema
C)query
D)metadata

Question 33

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

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

Question 34

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 35

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

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

Question 36

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)imitable key
B)main key
C)foreign key
D)primary key

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

The smallest piece of data is called a_________ .

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

Question 39

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 query
B)database model
C)database system
D)database catalog

Question 40

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 41

_________involves high volumes of data compiled from traditional,ordinary business activities,as well as newer,nontraditional sources.

A)Metadata
B)Schema
C)Data dictionary
D)Big Data

Question 42

In the_________ phase,specialists ensure that all data is consistent.

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

Question 43

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 44

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 45

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

Question 46

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

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

Question 47

The lack of a_________ in Big Data can make data collected from nontraditional sources a challenge to analyze.

A)granular level of storage
B)data warehouse
C)nontraditional data
D)traditional data structure

Question 48

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

Question 49

In the database approach,a(n)_________ is any object about which an organization chooses to collect data.

Question 50

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

Question 51

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

Question 52

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

Question 53

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 54

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

Question 55

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

Question 56

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 57

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 58

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 59

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 60

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 61

Describe the uses of a composite key with an example.

Question 62

What does metadata include?

Question 63

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

Question 64

-------- means data about data.

Question 65

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

Question 66

What are the advantages to integrating SQL in a DBMS?

Question 67

_________is a magnification or expansion of the amount,types,and level of detail of data that is collected and stored.

Question 68

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

Question 69

Discuss the security issues concerning databases.

Question 70

Explain the impact of databases on businesses.