Chapter 5 Database

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

A

A data warehouse contains data that have been processed in all the following ways except: A. Separated B. Cleaned C. Transformed D. Cataloged

A

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

A

Database development involves defining and organizing the _______________ of the data needed to build a database. A. structure B. content C. relationships D. All of the choices are correct.

A

Databases contain data elements that describe both entities and the _______________ among entities. A. relationships B. disparities C. subsets D. applications

A

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

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 B. relational C. network D. object-oriented

A

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.

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 B. morphing C. duplication D. cloning

A

The primary challenge of a distributed database is: A. Data accuracy B. Data transmission speed C. Storage costs D. Data security

A

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

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 B. link C. merge D. select

A

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.

A

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.

A

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 group of related records is a data file, or a _______________. A. field B. record C. table D. database

C

A(n) _______________ is an integrated collection of logically related data elements. A. master file B. program base C. database D. integrated file

C

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

C

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

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. A. network B. relational C. hierarchical D. object-oriented

C

Many end users have trouble correctly phrasing database language search queries, so most end-user DBMS packages now offer _______________ methods. A. speech recognition B. command line C. GUI D. All of the choices are correct.

C

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

C

The _______________ model is the most widely used database structure today. A. network B. object-oriented C. relational D. hierarchical

C

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

C

The basic form of a SQL query is: A. SELECT ¼ AND ¼ OR B. SELECT ¼ WHERE ¼ FROM ¼ C. SELECT ¼ FROM ¼ WHERE ¼ D. AND ¼ OR ¼ NOT ¼

C

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

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? A. Common databases B. Distributed databases C. External databases D. Local 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? A. Hierarchical B. Network C. Object-oriented D. Relational

C

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.

C

A record represents a collection of _______________ that describe an entity. A. characters B. fields C. files D. attributes

D

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

D

Boolean logic deals with three logical operators: A. AND, OR, and BUT B. AND, NOT, and BUT C. OR, BUT, and NOT D. AND, OR, and NOT

D

A DBMS query language is designed to: A. Support information systems professionals in the development of complex application software B. Support end users who wish to obtain ad hoc reports C. Provide efficient batch mode processing of the database D. Specify the content, relationships, and structure of a database

B

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

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 _______________. A. data mart B. data warehouse C. transaction processing mart D. data repository

B

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

B

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.

B

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.

B

All of the following are major functions of a database management system except: A. Creating new databases and database applications B. Identifying insufficient data processing or storage needs C. Maintaining the quality of the data in an organization's databases D. Using the databases of an organization to provide the information needed by its end users

B

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

B

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

B

The database maintenance process is accomplished via: A. Hierarchical database systems that provide flexibility and network databases B. Transaction processing systems and other end user applications, with the support of the DBMS C. Graphical query languages correctly phrasing SQL D. File processing systems with the support of 4GLs

B

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

B

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

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? A. Hierarchical B. Network C. Object-oriented D. Relational

B

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.

B

_______________ is the most commonly used database application for the PC. A. Oracle 10g B. Microsoft Access C. DB2 D. SQL Server

B

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

D

Database management involves the use of database management software to control how databases are _______________. A. created B. interrogated C. maintained D. All of the choices are correct.

D

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.

D

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.

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 _______________. A. records B. rows C. columns D. relations

D

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

D

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.

D

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

D

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.

D

_______________ 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

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. A. Relational B. Object-oriented C. Inter-relational D. Multidimensional

D

n mainframe and server computer systems, the database management system controls the _______________ of the databases of computer-using organizations. A. maintenance B. development C. use D. All of the choices are correct.

D