Database Exam 1 Quizzes

Select the correct statement.

• Data and information are essentially the same thing.

• Data is the result of processing raw facts to reveal its meaning.

• Information is a building block of data.

• Information is the result of processing raw facts to reveal its meaning.

Select the best description of a database.

• A database stores only information.

  
  

• A database is a system that shares duplicate data.

  
  

• A database is a shared, integrated computer structure that stores data and its corresponding metadata.

  
  

• A database is a computer structure that shares and stores numbers.

  
  

Select what IS NOT correct regarding metadata.

• Metadata is data about data.

  
  

• Metadata helps to integrate and manage end-user data.

  
  

• Metadata is data between raw facts and information.

  
  

• Metadata describe the data characteristics and the set of relationships that links the data found within the database.

  
  

Select what IS NOT correct regarding a database management system (DBMS).

• It increases the risk of data security breaches.

  
  

• It manages the database structure.

  
  

• It is a collection of programs.

  
  

• It controls access to data stored in the database.

  
  

Select what IS NOT an advantage of a database management system (DBMS)

• It improves data sharing.

  
  

• It provides better data integration.

  
  

• It maximizes the cost of data manipulation. 

  
  

• It improves data security.

  
  

Select the database classification by the number of users supported.

• Binary database and tertiary database.

  
  

• Single-user database and multiuser database.

  
  

• Interactive database and remote database.

  
  

• Group database and proprietary database.

  
  

Select what IS NOT a database classification by location.

• Centralized database.

  
  

• Distributed database.

  
  

• Parallel database.

  
  

• Cloud database.

  
  

Select the database that contains data focused on specific subject areas.

• General purpose database.

  
  

• Operational database.

  
  

• Distributed database.

  
  

• Discipline-specific database.

  
  

Select the best definition of an analytical database.

• It stores historical data and business metrics used exclusively for tactical or strategic decision making.

  
  

• It supports a company’s day-to-day operations.

  
  

• It contains a wide variety of data used in multiple disciplines.

  
  

• It stores data for mathematical analysis.

  
  

Select what IS NOT correct.

• Unstructured data is data that exists in its original (raw) state—that is, in the format in which it was collected. 

  
  

• Structured data is the result of formatting unstructured data to facilitate storage, use, and generation of information.

  
  

• Semi-structured data has already been processed to some extent.

  
  

• It is not possible the classification of databases using the degree to which the data is structured