Quiz: K201 Lecture Exam 1 Practice Test

48 Questions | Total Attempts: 2401

SettingsSettingsSettings
Quiz: K201 Lecture Exam 1 Practice Test - Quiz

Data is the fuel that drives the industries and businesses today. This quiz "k201 lecture exam 1" practice test contains various questions related to the industry, management, data, and how one can take the industry to new heights. The quiz is based on the theoretical aspect of it; performing well in the quiz will help you in your career too, as it will increase your knowledge about the industry functions. If you like the quiz, share it with others. All the best!


Questions and Answers
  • 1. 
    In order for data to be considered timely it must be delivered in real time.
    • A. 

      True

    • B. 

      False

  • 2. 
    The need for collaboration is greatest for _____ decisions
    • A. 

      Operational

    • B. 

      Procedural

    • C. 

      Managerial

    • D. 

      Strategic

  • 3. 
    Good data is always worth the cost, no matter how expensive.
    • A. 

      True

    • B. 

      False

  • 4. 
    Keeping track of data involving multiple themes such as employees, transactions, customers, supplies, etc. should be done with which of the following?
    • A. 

      A spreadsheet

    • B. 

      A database

    • C. 

      A filing cabinet

    • D. 

      None of the above

  • 5. 
    Margaret finds that calling all her senior supervisors and quality managers for a face-to-face meeting is not feasible. She arranges for a multiparty text chatting session involving all of them. This is an example of asynchronous communication.
    • A. 

      True

    • B. 

      False

  • 6. 
    Version-management systems ________.
    • A. 

      Track changes to shared documents

    • B. 

      Allow checkout of documents before they are edited

    • C. 

      Provide workflow control to manage the activities that are predefined by the group

    • D. 

      Provide version to documents

  • 7. 
    The data displayed in Design View of a table in an Access database is an example of
    • A. 

      Descriptive information

    • B. 

      Metadata

    • C. 

      Field names

    • D. 

      Tuples

  • 8. 
    A database is simply a group of tables or files.
    • A. 

      True

    • B. 

      False

  • 9. 
    How many primary functions does a database management system (DBMS) have?
    • A. 

      3 primary functions

    • B. 

      5 primary functions

    • C. 

      1 primary function

    • D. 

      4 primary functions

  • 10. 
    Information systems that process operational, social, and other data to identify patterns, trends, and relationships for use by business professionals are known as
    • A. 

      Data Mining (DM) Systems

    • B. 

      Business Intelligence (BI) Application

    • C. 

      Business Intelligence (BI) Systems

    • D. 

      Business Knowledge (BK) Systems

  • 11. 
    The patterns, trends and relationships produced by these information systems are referred to as
    • A. 

      Business intelligence

    • B. 

      Business data

    • C. 

      Business knowledge

    • D. 

      None of the above

  • 12. 
    An inventory report set to run automatically when an item reaches a critical low point is an example of pull publishing.
    • A. 

      True

    • B. 

      False

  • 13. 
    Which of the following is the first primary activity in the BI process?
    • A. 

      Acquire data

    • B. 

      Cleanse data

    • C. 

      Publish results

    • D. 

      Analyze data

  • 14. 
    One of the main benefits of BI Analysis is that there are no discrepancies in the data acquired from multiple sources.
    • A. 

      True

    • B. 

      False

  • 15. 
    Which of the following statements is true about operational and purchased data?
    • A. 

      Problematic operational data are termed rough data

    • B. 

      It is always better to have data with too coarse a granularity than with too fine a granularity

    • C. 

      If the data granularity is too coarse, the data can be made finer by summing and combining

    • D. 

      Purchased data often contains missing elements

  • 16. 
    Which of the following is an international standard language for processing a database?
    • A. 

      SQL

    • B. 

      MS Access

    • C. 

      DB2

    • D. 

      Paradox

  • 17. 
    The lost-update problem can be resolved by implementing multi-user database processing.
    • A. 

      True

    • B. 

      False

  • 18. 
    Microsoft Access belongs to which of the following DBMS catagories?
    • A. 

      Object-oriented DBMS

    • B. 

      Strategic DBMS

    • C. 

      Personal DBMS

    • D. 

      Enterprise DBMS

  • 19. 
    Operational data is structured for fast and reliable transaction processing.
    • A. 

      True

    • B. 

      False

  • 20. 
    A data ________ is a data collection that addresses a particular department or functional area of the business.
    • A. 

      Mine

    • B. 

      Cube

    • C. 

      Mart

    • D. 

      Warehouse

  • 21. 
    Data mart is another term used for a data warehouse
    • A. 

      True

    • B. 

      False

  • 22. 
    A ______ describes the data and relationships that will be stored in a datbase
    • A. 

      Query model

    • B. 

      Data application

    • C. 

      Data aggregator

    • D. 

      Data model

  • 23. 
    A ________ takes data from the data manufacturers, cleans and processes the data, and then stores it.
    • A. 

      Data warehouse

    • B. 

      Data model

    • C. 

      Data mine

    • D. 

      Data mart

  • 24. 
    Which of the following relationship types is described in the attached image? (crows feet between two entities)
    • A. 

      Many-to-many

    • B. 

      One-to-one

    • C. 

      One-to-many

    • D. 

      Many-to-one

  • 25. 
    ________ is the application of statistical techniques to find patterns and relationships among data for classification and prediction.
    • A. 

      Data mining

    • B. 

      Data warehousing

    • C. 

      Data optimization

    • D. 

      Database normalization

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.