COSC Final Exam Study Guide 1

30 Questions | Total Attempts: 39

SettingsSettingsSettings
Study Guide Quizzes & Trivia

Questions and Answers
  • 1. 
    Which of the following is a reason for creating a list instead of creating a database
    • A. 

      To organize data for simple tasks

    • B. 

      To prevent data inconsistency

    • C. 

      To prevent data redundancy

    • D. 

      To make it easier to share data in a central location

  • 2. 
    In a database, a field is a
    • A. 

      category of information

    • B. 

      Label

    • C. 

      table of information

    • D. 

      Group of related records

  • 3. 
    Data ________ means that the data contained in a database is accurate and reliable
    • A. 

      Efficiency

    • B. 

      Integrity

    • C. 

      Redundancy

    • D. 

      Consistency

  • 4. 
    Which of the following is NOT a database component
    • A. 

      Field

    • B. 

      List

    • C. 

      Record

    • D. 

      Table

  • 5. 
    In a database, a video clip would be stored in a(n) ________ field
    • A. 

      Text

    • B. 

      Object

    • C. 

      Memo

    • D. 

      Hyperlink

  • 6. 
    In a database, a text field capable of holding complete paragraphs is referred to as a ________ field
    • A. 

      Memo

    • B. 

      Document

    • C. 

      Paragraph

    • D. 

      Hypertext

  • 7. 
    Which of the following is NOT a likely primary key? 
    • A. 

      A driver's license number

    • B. 

      Street address

    • C. 

      Student ID number

    • D. 

      Social security number

  • 8. 
    Which type of database excels in the storage of structured (analytical) data?
    • A. 

      Relational

    • B. 

      hierarchical

    • C. 

      Multidimensional

    • D. 

      object-oriented

  • 9. 
    A ________ displays a subset of data from a table (or tables) based on the criteria specified.
    • A. 

      Database query

    • B. 

      Join query

    • C. 

      Select query

    • D. 

      Criteria query

  • 10. 
    Which of the following statements about object-oriented databases is FALSE?
    • A. 

      They are more complex than relational databases.

    • B. 

      They use a query language to access and manage data.

    • C. 

      They are good at handling unstructured data.

    • D. 

      They store data in table format.

  • 11. 
    Microsoft ________ is a database management system
    • A. 

      Visio

    • B. 

      Publisher

    • C. 

      Access

    • D. 

      Project

  • 12. 
    When creating a database with a DBMS, you must create a description of the data called the ________.
    • A. 

      Data type

    • B. 

      Data dictionary

    • C. 

      Database dictionary

    • D. 

      Database style guide

  • 13. 
    SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.
    • A. 

      Boolean algebra

    • B. 

      Relational algebra

    • C. 

      primary keys

    • D. 

      ) foreign keys

  • 14. 
    In Access, the Simple Query Wizard uses SQL to create a query.
    • A. 

      True

    • B. 

      False

  • 15. 
    A database formula instructs a database to search for particular pieces of data.
    • A. 

      True

    • B. 

      False

  • 16. 
    A ________ relationship indicates that for a record in one table, there can be many related records in another table.
    • A. 

      Many-to-one

    • B. 

      One-to-many

    • C. 

      One-to-one

    • D. 

      Single-to-many

  • 17. 
    A data mart is a large-scale electronic repository of data that contains and organizes all of an organization's data in one place.
    • A. 

      True

    • B. 

      False

  • 18. 
      A(n) ________ is designed to improve communications and assist employees in accomplishing their daily tasks.
    • A. 

      Office support system

    • B. 

      Transaction-processing system

    • C. 

      management information system

    • D. 

      Decision support system

  • 19. 
    In a transaction-processing system, if transaction data is accumulated until a certain point and then many transactions are processed all at once, this is called batch processing.
    • A. 

      True

    • B. 

      False

  • 20. 
    Management information systems provide reports that show conditions that are unusual or need attention from users of the system. These reports are called detail reports.
    • A. 

      True

    • B. 

      False

  • 21. 
    An example of ________ would be customer demographic data purchased from third parties or statistics compiled by the federal government
    • A. 

      internal data

    • B. 

      External data

    • C. 

      Imported data

    • D. 

      Metadata

  • 22. 
    The type of information system that uses model management systems is a(n) ________.
    • A. 

      transaction-processing system

    • B. 

      management information system

    • C. 

      Decision support system

    • D. 

      office support system

  • 23. 
    Classification, affinity grouping, and estimation are artificial intelligence methods used by managers to make their data more meaningful.
    • A. 

      True

    • B. 

      False

  • 24. 
    If a college keeps two lists, one for registration and one for overdue library books, both containing name and address information, this is an example of data _______
    • A. 

      Intergity

    • B. 

      Redundancy

    • C. 

      Completeness

    • D. 

      Normalization

  • 25. 
    An individual trained in the design and building of databases is called a database analyst.
    • A. 

      True

    • B. 

      False

Back to Top Back to top