Database Management System Quiz Questions

50 Questions | Total Attempts: 1099

SettingsSettingsSettings
Please wait...
Database Management System Quiz Questions

Take this quiz and learn how to do management of database information system. Let's start this quiz now!


Questions and Answers
  • 1. 
    A database can contribute to organizational success by providing managers and decision makers with timely, accurate, and relevant information based on data.
    • A. 

      True

    • B. 

      False

  • 2. 
                     A DBMS provides a single point of management and control over data resources.
    • A. 

      True

    • B. 

      False

  • 3. 
                      A database, a DBMS, and the application programs that use the data make up a query language.
    • A. 

      True

    • B. 

      False

  • 4. 
    A character can be an uppercase letter, lowercase letter, numeric digit, or special symbol.
    • A. 

      True

    • B. 

      False

  • 5. 
    The physical design of a database involves identifying relationships among the data items and grouping them in an orderly fashion.
    • A. 

      True

    • B. 

      False

  • 6. 
    Concurrency control usually involves understanding a specific business problem and analyzing the data and information needed to deliver a solution.
    • A. 

      True

    • B. 

      False

  • 7. 
    ER diagrams help ensure that the relationships among the data entities in a database are correctly structured so that any application programs developed are consistent with business operations and user needs.
    • A. 

      True

    • B. 

      False

  • 8. 
    Flat file databases do not use database models such as the relational model.
    • A. 

      True

    • B. 

      False

  • 9. 
    A database installed on a personal computer is typically meant for a single user.
    • A. 

      True

    • B. 

      False

  • 10. 
    In general, a DDL describes logical access paths and logical records in the database.
    • A. 

      True

    • B. 

      False

  • 11. 
    SQL is a visual approach to developing database queries or requests.
    • A. 

      True

    • B. 

      False

  • 12. 
    Data warehouses allow managers to roll up to take detailed data and generate aggregate or summary reports.
    • A. 

      True

    • B. 

      False

  • 13. 
    Competitive intelligence is the same as espionage.
    • A. 

      True

    • B. 

      False

  • 14. 
                     One of the most effective counterintelligence measures is to define “trade secret” information relevant to the company and control its dissemination.
    • A. 

      True

    • B. 

      False

  • 15. 
    Distributed databases simplify the task of controlling who accesses and changes data in a database.
    • A. 

      True

    • B. 

      False

  • 16. 
    Data mining provides top-down, query-driven data analysis; OLAP provides bottom-up, discovery-driven analysis.
    • A. 

      True

    • B. 

      False

  • 17. 
    An object-oriented database uses an object-oriented database management system (OODBMS) to provide a user interface and connections to other programs.
    • A. 

      True

    • B. 

      False

  • 18. 
    An object-relational database management system provides a complete set of relational database capabilities plus the ability for third parties to add new data types and operations to the database.
    • A. 

      True

    • B. 

      False

  • 19. 
    In an object-oriented database, a message is a procedure or action.
    • A. 

      True

    • B. 

      False

  • 20. 
    Spatial data technology involves using a database to store and access data according to the locations it describes and to permit spatial queries and analysis.
    • A. 

      True

    • B. 

      False

  • 21. 
    A ____ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.
    • A. 

      Database management system

    • B. 

      Data model

    • C. 

      DDL

    • D. 

      Data warehouse

  • 22. 
    A ____ is a skilled and trained IS professional who directs all activities related to an organization’s database, including providing security from intruders.
    • A. 

      System administrator

    • B. 

      Software engineer

    • C. 

      Database technician

    • D. 

      Database administrator

  • 23. 
                     A ____ is the basic building block of information.
    • A. 

      Record

    • B. 

      File

    • C. 

      Field

    • D. 

      Character

  • 24. 
    A ____ is typically a name, number, or combination of characters that describes an aspect of a business object or activity.
    • A. 

      Record

    • B. 

      File

    • C. 

      Field

    • D. 

      Character

  • 25. 
    A collection of related data fields is a(n) ____.
    • A. 

      Record

    • B. 

      File

    • C. 

      Entity

    • D. 

      Character