Database Test 1 Study guide

One of the advantages of database systems is that ___

• Database systems decreases end user productivity

  
  

• Database systems enable the data in the database to be shared among multiple applications or users.

  
  

• Database systems do not integrate many different users' data into a single all-encompassing data repository.

  
  

• Database systems maximizes data inconsistency

  
  

Which of the following is an advantage of a database compared to a file processing system?

• simpler recovery

  
  

• fast processing of sequential data

  
  

• sharing of data

• lower cost

  
  

Database management System allows specific users to access specific part of the database. This capability is not available if you are using File System"
The above statement refers to the database ability to-

• Recover damage or lost data

  
  

• Limit Access Control

  
  

• Create Backup

  
  

• Allows multiple access to the database

As a database developer, how would you explain how a database structure in a DBMS is stored?

• collection of queries

• 
  collection of files

• set of key/value pairs

• single file

 "Errors are easily identify and corrected thus improving data quality"
The above statement describes--------------------

The middle level of the three-level database architecture, containing the entire information structure as seen by the DBA is the

• logical

• internal

• physical

• external

Database access by two or more users at the same time is described as

• concurrent

• dependent

• independent

• serial

File System means that each department in an organization has their own sets of files concerning the same subjects or items. This will lead to....

• Increase data Redundancy

• Increase Data Security

• Increase cost of managing the system

  
  

• Increase the integrity of the data.

_______ are persons, places, events, objects, or concepts about which data is collected.

Which of the answers below is one of the problems with File system Data Processing?

• Lengthy development time

• Reduced costs

  
  

• Ease of getting quick answers

  
  

• Simple system administration