Data Base Management System

15 Questions

Settings
Please wait...
Data Management Quizzes & Trivia

Paper 1


Questions and Answers
  • 1. 
    What is the language used by most of the DBMSs for helping their users to access data?
    • A. 

      High level language

    • B. 

      SQL

    • C. 

      Query Language

    • D. 

      4GL

  • 2. 
    Which of the following is a problem of file management system?
    • A. 

      Difficult to update

    • B. 

      Lack of data independence

    • C. 

      Data redundancy

    • D. 

      program dependence

    • E. 

      All of above

  • 3. 
    Which of the following is true of a network structure?
    • A. 

      t is a physical representation of the data

    • B. 

      It allows a many-to-many relationship

    • C. 

      It is conceptually simple

    • D. 

      It will be dominant data base of the future

  • 4. 
    One data dictionery software package is called
    • A. 

      DB/DC dictionary

    • B. 

      TOTAL

    • C. 

      ACCESS

    • D. 

      Data Manager

    • E. 

      Datapac

  • 5. 
    The function of a database is
    • A. 

      To check all input data

    • B. 

      To check all spelling

    • C. 

      To collect and organize input data

    • D. 

      To output data

  • 6. 
    The model for a record management system might be
    • A. 

      Handwritten list

    • B. 

      A Rolodex card file

    • C. 

      A business form

    • D. 

      All of above

  • 7. 
    Primitive operations common to all record management system include
    • A. 

      Print

    • B. 

      Sort

    • C. 

      Look-up

    • D. 

      All of above

  • 8. 
    In a large DBMS
    • A. 

      Each user can "see" only a small part of the entire database

    • B. 

      Each subschema contains every field in the logical schema

    • C. 

      Each user can access every subschema

    • D. 

      All of the above

  • 9. 
    Which of the following fields in a student file can be used as a primary key?
    • A. 

      Class

    • B. 

      Social Security Number

    • C. 

      GPA

    • D. 

      Major

  • 10. 
    Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
    • A. 

      Report writer

    • B. 

      Data manipulation language

    • C. 

      Transaction log

    • D. 

      Query language

  • 11. 
    In the DBMS approach, application programs perform the 
    • A. 

      Storage function

    • B. 

      Processing functions

    • C. 

      Access control

    • D. 

      None of the above

  • 12. 
    A set of programs that handle a firm's database responsibilities is called
    • A. 

      Database management system (DBMS)

    • B. 

      Database processing system (DBPS)

    • C. 

      Data management system (DMS)

    • D. 

      All of above

  • 13. 
    Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
    • A. 

      Full media

    • B. 

      Multimedia

    • C. 

      Graphics media

    • D. 

      Hypertext

  • 14. 
    A record management system
    • A. 

      Can be used to extract information stored in a computer file

    • B. 

      Always uses a list as its model

    • C. 

      Can handle many files of information at a time

    • D. 

      Both a and b

  • 15. 
    A command that lets you change one or more fields in a record is
    • A. 

      Lookup

    • B. 

      Insert

    • C. 

      Delete

    • D. 

      Modify