Starting from:
$22.99

$16.99

Chapter 05 Data Resource Management Solution

Chapter 05 Data Resource Management  Solution

True / False Questions

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

 True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

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

True    False

29.       DBMS packages play a major role in application development.

True    False

Multiple Choice Questions

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

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

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

A.      characters

B.      fields

C.      files

D.     attributes

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

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

A.      field

B.      record

C.      table

D.     database

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

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

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

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

A.      master file

B.      program base

C.      database

D.     integrated file

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

A.      relationships

B.      disparities

C.      subsets

D.     applications

 

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

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

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

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

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

A.      network

B.      object-oriented

C.      relational

D.     hierarchical

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

 

 

 

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

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

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

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

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

A.      Oracle 10g

B.      Microsoft Access

C.      DB2

D.     SQL Server

51.       _______________ 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

 

 

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

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

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

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

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

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

A.      hierarchical

B.      network

C.      relational

D.     object-oriented

 

 

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

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

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

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

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

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

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

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

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

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

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

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

70.       The primary challenge of a distributed database is:

A.      Data accuracy

B.      Data transmission speed

C.      Storage costs

D.     Data security

 

 

 

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

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

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

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

A.      Separated

B.      Cleaned

C.      Transformed

D.     Cataloged

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

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

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

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

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

80.       In 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.

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

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

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

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

85.       The basic form of a SQL query is:

A.      SELECT … AND … OR

B.      SELECT … WHERE … FROM …

C.      SELECT … FROM … WHERE …

D.     AND … OR … NOT …

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

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

 

 

 

 

More products