Chapter 5
A data warehouse contains data that have been processed in all the following ways except: A. Separated
a
A is an overall logical view of the relationships among the data elements in a database. A. schema
a
According to the textbook case, on cars: A. Cars are a goldmine of consumer information
a
Database development involves defining and organizing the of the data needed to build a database. A. structure
a
Databases contain data elements that describe both entities and the among entities. A. relationships
a
From a logical point of view, a(n)is the smallest data element that can be observed and manipulated. A. character
a
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
a
Large organizations usually place control of enterprise-wide database development in the hands of A. Database administrators (DBAs)
a
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
a
The primary challenge of a distributed database is: A. Data accuracy
a
The tables in a relational database are flat files which have rows and columns. Each column represents a in the file. A. field
a
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
a
Variable-length records contain: A. both a variable number of fields and variable field lengths.
a
Which of the following is true of data in a data warehouse? A. Data in operational databases is ever
a
A DBMS query language is designed to: B. Support end users who wish to obtain ad hoc reports
b
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 _______________. B. data warehouse
b
A database with a(n) data structure can easily handle a many-to-many data relationship. B. network
b
A is an overall logical view of the relationships needed to support specific end-user application programs that will access the databaseB. subschema
b
According to one database pioneer, the future development of databases and data warehouses will depend on B. columns
b
According to the text, most data warehouses will run in a column format. B. 50 times faster
b
All of the following are major functions of a database management system except: B. Identifying insufficient data processing or storage needs
b
Database management packages based on the model can link data elements from various tables to provide information to users. B. relational
b
The database maintenance process is accomplished via: B. Transaction processing systems and other end user applications, with the support of the DBMS
b
The tables in a relational database are flat files which have rows and columns. Each row represents a in the file. B. record
b
When independent of any other files related to it, a single table is referred to as a(n): B. Flat file
b
Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths? B. Network
b
Which of the following is true of data marts? B. They are a subset of a data warehouse.
b
_______________ is the most commonly used database application for the PC.B. Microsoft Access
b
A database with a(n) _______________ data structure can easily handle ad hoc requests for information. A. hierarchical B. network C. relational D. object-oriented
c
A(n) _______________ is an integrated collection of logically related data elements. C. database
c
According to the textbook case, the innovation of the open-source product Hadoop is C. that it has no proprietary predecessor
c
All of the following contribute to problems when using a file management approach except: C. Data independence
c
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. C. hierarchical
c
Many end users have trouble correctly phrasing database language search queries, so most end-user DBMS packages now offer methods. C. GUI
c
The _______________ database structure is considered one of the key technologies of a new generation of Web-based applications. C. object-oriented
c
The basic form of a SQL query is: C. SELECT ¼ FROM ¼ WHERE ¼
c
The model is the most widely used database structure today. C. relational
c
The operation is used to create a subset of the columns contained in the temporary tables created by the select and join operations. C. project
c
The physical design stage of database development: C. Determines the data storage structures and access methods
c
What type of databases are employees using when they access online data banks, whether those data banks are free or paid for through subscriptions? C. External databases
c
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? C. Object-oriented
c
Which of the following statements concerning the replication and duplication process for updating distributed databases is correct? 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
c
According to the textbook case, file processing in Hadoop is not halted by hardware failures because _______________. D. Hadoop keeps three (3) copies of all data
d
Boolean logic deals with three logical operators: D. AND, OR, and NOT
d
Database administrators and database design analysts work with end users and systems analysts to do all of the following except: D. Enter live data into the system until it has proven to be reliable
d
Database management involves the use of database management software to control how databases are _______________. D. All of the choices are correct.
d
Fixed-length records contain: D. both a fixed number of fields and fixed field lengths.
d
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 D. relations
d
Object technology allows designers to do all of the following except: D. Substantially reduce the file size of designs
d
Operational databases store the detailed data needed to support the business processes and operations of a company. They are also called D. All of the choices are correct.
d
The _______________ stage of database development translates the conceptual models into the data model of a DBMS. D. logical design
d
Which of the following is a legitimate use for data mining? D. All of the choices are correct.
d
_______________ are used to model the relationships among the many entities involved in business processes. D. Subschema diagrams
d
_______________ 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. D. Multidimensional
d
n mainframe and server computer systems, the database management system controls the of the databases of computer-using organizations. D. All of the choices are correct.
d
