Data And Databases Trivia Quiz!

15 Questions | Total Attempts: 16

SettingsSettingsSettings
Please wait...
Database Quizzes & Trivia

.


Questions and Answers
  • 1. 
    Organizations generally use a software system to help them create databases, change a database’s structure, perform data analysis, and manage their data. This category of software application is called______
    • A. 

      Enterprise database system.

    • B. 

      Spreadsheet.

    • C. 

      Database Management Systems (DBMS).

    • D. 

      Microsoft Access

    • E. 

      Structured Query Language (SQL).

  • 2. 
    The term [Blank] refers to data used to describe other data, such as the length of a movie in a streaming video service program.
  • 3. 
    Which of the following statements are correct about knowledge management? 
    • A. 

      All companies accumulate knowledge over the course of their existence.

    • B. 

      Knowledge can be an important organizational resource.

    • C. 

      Unlike information, knowledge cannot be stored.

    • D. 

      Only information, and not knowledge, can be stored in the heads of an organization’s employees.

    • E. 

      Organizational knowledge is always written down or saved.

    • F. 

      Knowledge is the same as data.

    • G. 

      Knowledge management is the process of formalizing capture, indexing, and storing knowledge to benefit from organizational experiences and insights.

  • 4. 
    Organizations generally use a software system to help them create databases, change a database’s structure, perform data analysis, and manage their data. This category of software applications is called a(n):
    • A. 

      Enterprise Database System

    • B. 

      Spreadsheet

    • C. 

      Structured Query Language (SQL)

    • D. 

      Database Management Systems (DBMS)

    • E. 

      Microsoft Access

  • 5. 
    The most popular form of database today is the [Blank] database, in which categories of data are connected by attributes they have in common.
  • 6. 
    Which of the following statements best describes why organizations develop and use data warehouses?
    • A. 

      Data warehouses enable line workers to view data in a decentralized manner.

    • B. 

      Direct analysis of data needed for day-to-day operations is a good idea.

    • C. 

      Data warehouses provide a centralized view of all data collected across an enterprise.

    • D. 

      Data warehouses are useful for time-invariant data.

    • E. 

      Although data warehouses do not provide tools for data analysis and manipulation, inexpensive third-party add-ons exist to perform those functions.

    • F. 

      Data warehouses do not require a company to worry about data consistency.

  • 7. 
    [Blank] is the process of analyzing data to find previously unknown trends, patterns, and associations in order to make decisions.
  • 8. 
    Which stage of the data mining life cycle is focused on understanding the issue and domain environment at hand?
    • A. 

      Exploring the database

    • B. 

      Preparation of creating a data mining mode

    • C. 

      Creating the database

    • D. 

      Problem definition

  • 9. 
    The properties of an acid relational database are atomic, isolated, durable, and ____
    • A. 

      Congruent

    • B. 

      Converted

    • C. 

      Consistent

    • D. 

      Correlated

  • 10. 
    Knowledge management is the process of formalizing the capturing, indexing, and ______ of a company's knowledge.
    • A. 

      Storing

    • B. 

      Distributing

    • C. 

      Editing

    • D. 

      Securing

  • 11. 
    The open-source MySQL is an enterprise database.
    • A. 

      True

    • B. 

      False

  • 12. 
    SQL is a language that can't be used to work with a relational database.
    • A. 

      True

    • B. 

      False

  • 13. 
    Big data refers to such massively large data sets that conventional database tools do not have the processing power to analyze them.
    • A. 

      True

    • B. 

      False

  • 14. 
    In which approach reduces duplication of data between tables and gives the table as much flexibility as possible.
    • A. 

      Dimensional

    • B. 

      Inmon

    • C. 

      Operational

    • D. 

      Normalization

    • E. 

      Formalization

Related Topics