Deck 5: Data Resource Management

Question 1

The project operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

Answer 1

True

Question 2

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.

Answer 2

False

Question 3

Variable-length records contain a variable number of fields with fixed field lengths.

Answer 3

False

Question 4

A master file is an integrated collection of logically related data elements.

Question 5

Database management packages based on the relational model can link data elements from various tables to provide information to users.

Question 6

Multidimensional databases have become the least popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

Question 7

A data model serves as a logical framework on which to base the physical design of a database.

Question 8

The network model can easily handle ad hoc requests for information, whereas the hierarchical model cannot.

Question 9

When independent of any other files related to it, a single table is referred to as a compressed file.

Question 10

Databases contain data elements that describe both entities and the relationships among entities.

Question 11

A large database system is often distributed into smaller databases based on some logical relationship between the data and the location of the databases.

Question 12

Distributed databases can reside on network servers on the World Wide Web, on corporate intranets, or on corporate extranets.

Question 13

A database with a network data structure can easily handle a many-to-many data relationship, whereas a hierarchical model cannot.

Question 14

In a distributed database system, each location gains control of its local data, but loses access to data in other locations.

Question 15

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs) and other database specialists.

Question 16

Relational databases are more difficult for programmers to work with and more difficult to maintain than the hierarchical and network models.

Question 17

The multidimensional database structure is considered one of the key technologies of a new generation of Web-based applications.

Question 18

Files are frequently classified by the application for which they are primarily used, such as a payroll file or an inventory file.

Question 19

An active data dictionary will prevent a data entry program from using a nonstandard definition of a customer record.

Question 20

A major benefit of multidimensional databases is that they are a compact and easy-to-understand way to visualize and manipulate data elements that have many interrelationships.

Question 21

In all information systems, data resources must be organized and structured in some logical manner, so that they can be:

A) Easily accessed
B) Processed efficiently
C) Retrieved quickly
D) All of the choices are correct.

Question 22

From a logical point of view, a(n) _______________ is the smallest data element that can be observed and manipulated.

A) character
B) bit
C) attribute
D) byte

Question 23

Variable-length records contain:

A) both a variable number of fields and variable field lengths.
B) both a variable number of fields and fixed field lengths.
C) both a fixed number of fields and variable field lengths.
D) both a fixed number of fields and fixed field lengths.

Question 24

In file processing systems, it was easy for data elements, such as stock numbers and customer addresses, to be defined differently by different end users and applications.

Question 25

The Internet is nothing more than the world's largest database.

Question 26

Boolean logic was developed during the latter part of the 1900s.

Question 27

Databases contain data elements that describe both entities and the _______________ among entities.

A) relationships
B) disparities
C) subsets
D) applications

Question 28

A(n) _______________ is an integrated collection of logically related data elements.

A) master file
B) program base
C) database
D) integrated file

Question 29

When independent of any other files related to it, a single table is referred to as a(n):

A) Independent file
B) Flat file
C) Hierarchical file
D) Non-variable file

Question 30

Having data in independent files makes it easier to provide end users with information for ad hoc requests.

Question 31

A record represents a collection of _______________ that describe an entity.

A) characters
B) fields
C) files
D) attributes

Question 32

All the fields used to describe the attributes of an entity are grouped to form a(n) _______________.

A) field
B) record
C) file
D) database

Question 33

In file processing systems, application programs typically contain references to the specific format of the stored data.

Question 34

Distributed databases require fewer resources when it comes to computing power and bandwidth.

Question 35

DBMS packages play a major role in application development.

Question 36

In a traditional file processing approach, each business application is designed to use one or more specialized data files containing only specific types of data records.

Question 37

A group of related records is a data file, or a _______________.

A) field
B) record
C) table
D) database

Question 38

Fixed-length records contain:

A) both a variable number of fields and variable field lengths.
B) both a variable number of fields and fixed field lengths.
C) both a fixed number of fields and variable field lengths.
D) both a fixed number of fields and fixed field lengths.

Question 39

One drawback to the database duplication process is that no changes can ever be made to any database other than the master. Otherwise, local changes will be overwritten during the duplication process.

Question 40

Automobiles contain very little useful business information about consumers.

Question 41

The tables in a relational database are flat files which have rows and columns. Each row represents a _______________ in the file.

A) field
B) record
C) file
D) relation

Question 42

Using a relational database, a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is in one big table. This is the _______________ operation.

A) join
B) link
C) merge
D) select

Question 43

Which database structure works effectively with complex data types, such as video clips, audio segments, and other subsets of Web pages, and is considered one of the key technologies of Web-based applications?

A) Hierarchical
B) Network
C) Object-oriented
D) Relational

Question 44

According to one database pioneer, the future development of databases and data warehouses will depend on _______________.

A) rows
B) columns
C) transaction
D) All of the choices are correct.

Question 45

The _______________ model is the most widely used database structure today.

A) network
B) object-oriented
C) relational
D) hierarchical

Question 46

The _______________ operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations.

A) link
B) relate
C) project
D) merge

Question 47

The object-oriented database model supports _______________. That is, new objects can be automatically created by replicating some or all of the characteristics of one or more parent objects.

A) inheritance
B) morphing
C) duplication
D) cloning

Question 48

Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?

A) Hierarchical
B) Network
C) Object-oriented
D) Relational

Question 49

A database with a(n) _______________ data structure can easily handle a many-to-many data relationship.

A) hierarchical
B) network
C) relational
D) object-oriented

Question 50

Object technology allows designers to do all of the following except:

A) Develop product designs
B) Replicate product designs and then modify them to create new product designs
C) Save designs as objects in an object-oriented database
D) Substantially reduce the file size of designs

Question 51

A database with a(n) _______________ data structure can easily handle ad hoc requests for information.

A) hierarchical
B) network
C) relational
D) object-oriented

Question 52

Early mainframe DBMS packages used the _______________ structure, in which all records are dependent and arranged in multilevel structures, consisting of one root record and any number of subordinate levels.

A) network
B) relational
C) hierarchical
D) object-oriented

Question 53

In a(n) _______________ database structure, all of the relationships among records are one-to-many, because each data element is related to only one element above it.

A) hierarchical
B) relational
C) network
D) object-oriented

Question 54

_______________ databases have become the most popular structure for analytical databases that support online analytical process (OLAP) applications, in which fast answers to complex queries are expected.

A) Relational
B) Object-oriented
C) Inter-relational
D) Multidimensional

Question 55

The _______________ database structure is considered one of the key technologies of a new generation of Web-based applications.

A) hierarchical
B) relational
C) object-oriented
D) multidimensional

Question 56

Large organizations usually place control of enterprise-wide database development in the hands of _______________.

A) Database administrators (DBAs)
B) Automated CASE tools
C) End users
D) All of the choices are correct.

Question 57

Database management packages based on the _______________ model can link data elements from various tables to provide information to users.

A) object-oriented
B) relational
C) network
D) hierarchical

Question 58

The tables in a relational database are flat files which have rows and columns. Each column represents a _______________ in the file.

A) field
B) record
C) file
D) relation

Question 59

In the relational database model, all data elements within the database are viewed as being stored in the form of simple two-dimensional tables, sometimes referred to as _______________.

A) records
B) rows
C) columns
D) relations

Question 60

_______________ is the most commonly used database application for the PC.

A) Oracle 10g
B) Microsoft Access
C) DB2
D) SQL Server

Question 61

The _______________ stage of database development translates the conceptual models into the data model of a DBMS.

A) data planning
B) requirements specification
C) conceptual design
D) logical design

Question 62

_______________ are used to model the relationships among the many entities involved in business processes.

A) Entity-relationship diagrams
B) Data-flow diagrams
C) Schema diagrams
D) Subschema diagrams

Question 63

According to the textbook case, on cars:

A) Cars are a goldmine of consumer information
B) Gathering consumer information from cars is not technologically feasible
C) Gathering consumer information from cars is not legal by federal right-to-privacy standards
D) Gathering consumer information from cars is not feasible from a financial perspective

Question 64

Operational databases store the detailed data needed to support the business processes and operations of a company. They are also called _______________.

A) Subject area databases
B) Transaction databases
C) Production databases
D) All of the choices are correct.

Question 65

Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?

A) The two terms are interchangeable because the processes work the same way
B) Duplication is the more complicated process because it has to identify one database as a master and prevent changes being made to any database other than the master
C) Replication is the more complicated process because it must find changes in each distributed database and make appropriate changes to make each database identical
D) None of the choices are correct.

Question 66

Which of the following is a legitimate use for data mining?

A) Performing "market-basket analysis" to identify new product bundles
B) Profiling customers
C) Finding the root cause of a quality or manufacturing problem
D) All of the choices are correct.

Question 67

Which of the following is true of data marts?

A) They hold data from many different data warehouses.
B) They are a subset of a data warehouse.
C) They focus on many generalized aspects of a company.
D) None of the choices are correct.

Question 68

Database administrators and database design analysts work with end users and systems analysts to do all of the following except:

A) Model business processes and the data they require
B) Determine what data definitions should be included in the database
C) Determine what structure or relationships should exist among the data elements
D) Enter live data into the system until it has proven to be reliable

Question 69

The physical design stage of database development:

A) Develops a model of business processes
B) Translates conceptual models into the data models
C) Determines the data storage structures and access methods
D) Defines the information needs of end users in a business process

Question 70

A _______________ is an overall logical view of the relationships needed to support specific end-user application programs that will access the database.

A) schema
B) subschema
C) logical data model
D) conceptual design

Question 71

What type of databases are employees using when they access online data banks, whether those data banks are free or paid for through subscriptions?

A) Common databases
B) Distributed databases
C) External databases
D) Local databases

Question 72

According to the textbook case, file processing in Hadoop is not halted by hardware failures because _______________.

A) Hadoop is a software product
B) Open-source products are not affected by hardware failures
C) Hadoop is an Internet product and does not need hardware
D) Hadoop keeps three (3) copies of all data

Question 73

All of the following contribute to problems when using a file management approach except:

A) Data redundancy
B) Lack of integration of data
C) Data independence
D) Lack of data integrity

Question 74

According to the text, most data warehouses will run _______________ in a column format.

A) 20 times faster
B) 50 times faster
C) 50 times slower
D) None of the choices are correct.

Question 75

A central source of data that have been cleaned, transformed, and cataloged so that they can be used for business analysis, market research, and decision support is called a _______________.

A) data mart
B) data warehouse
C) transaction processing mart
D) data repository

Question 76

A data warehouse contains data that have been processed in all the following ways except:

A) Separated
B) Cleaned
C) Transformed
D) Cataloged

Question 77

The primary challenge of a distributed database is:

A) Data accuracy
B) Data transmission speed
C) Storage costs
D) Data security

Question 78

According to the textbook case, the innovation of the open-source product Hadoop is _______________.

A) that it has not been sued by Google
B) that it actually works
C) that it has no proprietary predecessor
D) its algorithms run contrary to contemporary mathematics

Question 79

A _______________ is an overall logical view of the relationships among the data elements in a database.

A) schema
B) subschema
C) logical data model
D) conceptual design

Question 80

Which of the following is true of data in a data warehouse?

A) Data in operational databases is ever changing; data in data warehouses is static
B) Data in operational databases is static; data in data warehouses is ever changing
C) Data in operational databases can be cataloged; data in data warehouses cannot
D) None of the choices are correct.