Chapter 10 Review 

            DATABASE MANAGEMENT

 
Completion
Complete each sentence or statement.
 
                  1.   _________________________ is a collection of unprocessed items, which can include text,
numbers, images, audio, and video.
 

                  2.   _________________________ is processed data; that is, it is organized, meaningful, and
useful.
 

                  3.   A(n) _________________________ is a collection of data organized in a manner that

allows access, retrieval, and use of that data.
 

                  4.   With ___________________________________, users create a computerized database;

add, change, and delete data in the database; sort and retrieve data from the database; and create
forms and reports from the data in the database.
 

                  5.   _________________________ identifies the quality of data in a database.

 

                  6.   In the ASCII and EBCDIC coding schemes, each byte represents a single
_________________________, which can be a number, letter, punctuation mark, or other symbol.
 
                  7.   In the database pictured in the accompanying figure, a(n) _________________________ is
a combination of one or more related charters or bytes and is the smallest unit of data a user accesses.
 

                  8.   In the database pictured in the accompanying figure, a(n) _________________________
uniquely identifies each field.
 

                  9.   In the database pictured in the accompanying figure, the _________________________
defines the maximum number of characters a field can contain.
 

                  10.  In a database, the _________________________ specifies the kind of data a field can
contain and how the field is used.
 

                  11.  Text (also called _________________________), is a common data type that includes
letters, numbers, or special characters.
 

                  12.  Yes/No (also called _________________________), is a common data type that includes
only the values Yes or No (or True or False).
 

                  13.  Object (also called _________________________ for binary large object), is a common
data type that includes photograph, audio, video, or a document created in other applications.
 

                  14.  In a database, a(n) _________________________ is a group of related fields.

 

                  15.  In a database, a(n) _________________________ is a field that uniquely identifies each
record in a file.
 

                  16.  A(n) _________________________ is a collection of related records stored on a disk such
as a hard disk, CD-ROM, or DVD-ROM.
 

                  17.  _________________________ refers to the procedures that keep data current.
 
                  18.  _________________________ is the process of comparing data with a set of rules or
values to find out if the data is correct.
 

                  19.  Many database programs perform a(n) _________________________ that analyzes
entered data to help ensure that it is correct.
 

                  20.  Validity checks, also called _________________________, reduce data entry errors.
 

                  21.  A(n) _________________________ is a validity check that ensures users enter only
alphabetic data into a field.
 

                  22.  A(n) _________________________ is a validity check that ensures users enter only
numeric data into a field.
 

                  23.  A(n) _________________________ is a validity check that determines whether a number
is within a specified range.
 

                  24.  A(n) _________________________ is a number(s) or character(s) that is appended to or

inserted into a primary key field.
 

                  25.  In a typical _________________________, each department or area within an

organization has its own set of files.
 

                  26.  When a company uses the _________________________, many programs and users
share the data in a database.
 

                  27.  A(n) _________________________ is a program with which users interact that generally
has a more user-friendly interface than a DBMS.
 

                  28.  An application that supports a front-end program sometimes is called the
_________________________.
 

                  29.  A(n) _________________________ contains data about each file in a database and each
field within those files.
 

                  30.  Because a data dictionary contains details about the data in a database, some call it
_________________________.
 

                  31.  A(n) _________________________ is a value that a database initially displays in a field.
 

                  32.  A(n) _________________________ is a request for specific data from a database.
 

                  33.  A(n) _________________________ consists of simple, English-like statements that allow
users to specify the data to display, print, or store.
 

                  34.  Instead of learning the grammar and vocabulary associated with a query language, a(n)
_________________________ can be used to request data from a database.
 

                  35.  A(n) _________________________ is a window on the screen that provides areas for
entering or changing data in a database.
 

                  36.  A form that sends entered data across a network or the Internet is called a(n)
_________________________.
 

                  37.  A(n) _________________________ allows users to design a report on the screen, retrieve
data into the report design, and then display or print the report.
 
                  38.  _________________________ define the actions that a specific user or group of users can
perform with the data in a database.
 

                  39.  _________________________ are access privileges that specify a user can view, but
cannot change, the data in a database.
 

                  40.  _________________________ are access privileges that specify a user can view and
change the data in a database.
 

                  41.  A(n) _________________________, or copy, of the entire database should be made on a
regular basis.
 

                  42.  More complex DBMSs maintain a(n) _________________________, which is a listing of
activities that change the contents of a database.
 

                  43.  A DBMS places a copy of the record prior to a change, called the
_________________________, in the log.
 

                  44.  A DBMS places a copy of the record after a change, called the
_________________________, in the log.
 

                  45.  A DBMS that creates a log usually provides a(n) _________________________ that uses
the log and/or backup to restore a database when it becomes damaged or destroyed.
 

                  46.  In a(n) _________________________, the DBMS uses the log to reenter changes made to
a database since the last save or backup.
 

                  47.  In a(n) _________________________, the DBMS uses the log to undo any changes made
to a database during a certain period.
 

                  48.  A(n) _________________________ consists of rules and standards that define how a
database organizes data.
 

                  49.  Some databases are called _________________________ because they combine features
of the relational and object-oriented data models.
 

                  50.  A(n) _________________________ is a database that stores data in tables that consist of
rows and columns.
 

                  51.  The developer of a relational database refers to a file as a(n)

_________________________.
 

                  52.  The developer of a relational database refers to a record as a(n)

_________________________.
 

                  53.  The developer of a relational database refers to a field as a(n)

_________________________.
 

                  54.  ___________________________________ is a query language that allows users to

manage, update, and retrieve data.
 

                  55.  A(n) ___________________________________ stores data in objects.

 

                  56.  A(n) _________________________ is an item that contains data, as well as the actions
that read or process the data.
 
                  57.  A(n) _________________________ is an application appropriate for an object-oriented
database that contains text links to other types of documents.
 

                  58.  A(n) _________________________ is an application appropriate for an object-oriented

database that contains text, graphics, video, and sound.
 

                  59.  A(n) _________________________ is an application appropriate for an object-oriented

database that links to an e-form on a Web page.
 

                  60.  Object-oriented and object-relational databases often use a query language called
______________________________ to manipulate and retrieve data.
 

                  61.  A(n) _________________________ stores data in dimensions.

 

                  62.  A multidimensional database stores data in multiple dimensions, sometimes known as
a(n) _________________________, that allow users to access and analyze any view of the database
data.
 

                  63.  A(n) _________________________ is a huge database that stores and manages the data
required to analyze historical and current transactions.
 

                  64.  The data in a(n) _________________________ exists in many separate locations
throughout a network or the Internet.
 

                  65.  Data warehouses often use a process called _________________________ to find
patterns and relationships among data.
 

                  66.  A(n) _________________________ contains a database that helps a specific group or
department make decisions.
 

                  67.  A(n) _________________________ is a computer that stores and provides access to a
database.
 

                  68.  One type of program that manages the sending and receiving of data between the front
end and a database server is a(n) ___________________________________, which runs automatically
as soon as users click a button to send or receive information.
 

                  69.  In managing a company’s database, the _________________________ focuses on the

meaning and usage of data.
 

                  70.  In managing a company’s database, the _________________________ requires a

technical inside view of data.
 
1.    ANS:        Data                                      7.    ANS:        field                          
 

            2.    ANS:        Information                         

 
            8.    ANS:        field name                           
 

            3.    ANS:        database                             

 
            9.    ANS:        field size                              
 

            4.    ANS:        database software             10.  ANS:        data type                             
 

                                  database management             11.  ANS:        alphanumeric                       

 

system (DBMS)             12.  ANS:        Boolean                              

                                  database management
 

            13.  ANS:        BLOB                      

system
 

            14.  ANS:        record                      

                                  DBMS  

            15.  ANS:        key field

            5.    ANS:        Data integrity                      
 
                                  primary key
            6.    ANS:        character                            
 

 
            16.  ANS:        data file                               
 
  

            17.  ANS:        File maintenance       

 
            49.  ANS:        object-relational databases
 

            18.  ANS:        Validation                            

 
            50.  ANS:        relational database     
 

            19.  ANS:        validity check             51.  ANS:        relation                                

 

                                  validation rule

 
            52.  ANS:        tuple                         
 

            20.  ANS:        validation rules          

 
            53.  ANS:        attribute                              
 

            21.  ANS:        alphabetic check       

 
            54.  ANS:        Structured Query Language
            22.  ANS:        numeric check                     
 
(SQL)
            23.  ANS:        range check                        
 
                                  Structured Query Language
            24.  ANS:        check digit                           
 
                                  SQL
 

            25.  ANS:        file processing system

 
            55.  ANS:        object-oriented database
            26.  ANS:        database approach     (OODB)
                                  object-oriented database
 

            27.  ANS:        front end                             

                                  OODB
 

            28.  ANS:        back end                               

            56.  ANS:        object                       

 

            29.  ANS:        data dictionary  

                                  repository             57.  ANS:        hypertext database    

 

            58.  ANS:        hypermedia database 

 

            30.  ANS:        metadata                               

            59.  ANS:        Web database                     

 

            31.  ANS:        default value                          

            60.  ANS:        object query language

 

            32.  ANS:        query                        

(OQL)
 

            33.  ANS:        query language                    

 

                                  object query language

            34.  ANS:        query by example (QBE)
                                  OQL
                                  query by example  

                                  QBE             61.  ANS:        multidimensional database

 

            62.  ANS:        hypercube                           

 

            35.  ANS:        form  

                                  data entry form             63.  ANS:        data warehouse         

 

            64.  ANS:        distributed database   

 

            36.  ANS:        e-form  

                                  electronic form             65.  ANS:        data mining                          

 

            37.  ANS:        report generator             66.  ANS:        data mart                            
 

                                  report writer

 
            67.  ANS:        database server         
 

            38.  ANS:        Access privileges      

 
            68.  ANS:        CGI (Common Gateway
            39.  ANS:        Read-only privileges   Interface) script
                                  Common Gateway Interface
 

            40.  ANS:        Full-update privileges 

script
 

            41.  ANS:        backup                                

 

                                  CGI script

            42.  ANS:        log                              

            43.  ANS:        before image                                    69.  ANS:        database analyst (DA)
 

                                  data modeler

            44.  ANS:        after image                          
 

                                  database analyst

            45.  ANS:        recovery utility                     
 

                                  DA
            46.  ANS:        rollforward  

            70.  ANS:        database administrator

                                  forward recovery
 

(DBA)
            47.  ANS:        rollback                                   database administrator
                                  backward recovery
 
                                  DBA
            48.  ANS:        data model