Chap 11/12

In some database programs, a data file is referred to as a(n) ______. 

•   

  a.  

  table 

•   

  b.  

  unit 

•   

  c.  

  record 

•   

  d.  

  sheet 

2. The field ______ defines the maximum number of characters a field can contain. 

  

• a.  

  length 

• b.  

  width 

•   

  c.  

  capacity 

•   

  d.  

  Size 

   

A(n) ______ database stores data in tables that consist of rows and columns. 

• a.  

  multidimensional 

• b.  

  relational 

• c.  

  data warehouse 

•   

  d.  

  Distributed 

   

File ______ refers to the procedures that keep data current. 

•   

  a.  

  administration 

• b.  

  maintenance 

• c.  

  integrity 

• d.  

  validation 

______ compares data with a set of rules or values to determine if the data meets certain criteria. 

• a.  

  Evaluation 

• b.  

  Processing 

• c.  

  Analysis 

•   

  d.  

  Validation 

A(n) ______ is a number(s) or character(s) appended to or inserted in a primary key value. 

• a.  

  validator 

• b.  

  value-add 

• c.  

  address 

• d.  

  check digit.

______ data is stored in separate files in different departments. 

•   

  a.  

  Isolated 

•   

  b.  

  Exiled 

•   

  c.  

  Detached 

•   

  d.  

  Divorced 

During which phase of system development would you acquire any necessary hardware and software? 

• a.  

  Planning 

• b.  

  Analysis 

• c.  

  Design 

•   

  d.  

  Implementation

Which of the following best describes the function of a primary key? 

• a.  

  The first record in a data file 

•   

  b.  

  Another term for file name 

• c.  

  To uniquely identify each record in a file 

• d.  

  To provide decryption of data 

Which of the following is NOT an advantage of the database approach? 

•   

  a.  

  Eliminates redundant data 

•   

  b.  

  Improved data integrity 

•   

  c.  

  Easier access 

• d.  

  Reduced development time