Home / CSE MCQs / DBMS MCQs :: Storage Structure - DBMS

CSE MCQs :: DBMS MCQs

  1. The storage structure which do not survive system crashes are ______
  2. A.
    Volatile storage
    B.
    Non-volatile storage
    C.
    Stable storage
    D.
    Dynamic storage

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Storage devices like tertiary storage , magnetic disk comes under
  4. A.
    Volatile storage
    B.
    Non-volatile storage
    C.
    Stable storage
    D.
    Dynamic storage

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. For a transaction to be durable, its changes need to be written to ________ storage.
  6. A.
    Volatile storage
    B.
    Non-volatile storage
    C.
    Stable storage
    D.
    Dynamic storage

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. The unit of storage that can store one are more records in a hash file organization are
  8. A.
    Buckets
    B.
    Disk pages
    C.
    Blocks
    D.
    Nodes

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
  10. A.
    Storage
    B.
    Tertiary
    C.
    Secondary
    D.
    Cluster

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. A file produced by a spreadsheet
  12. A.
    is generally stored on disk in an ASCII text format
    B.
    can be used as is by the DBMS
    C.
    both a and b
    D.
    none of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. SDL means _____________
  14. A.
    Storage Discrete Language
    B.
    Storage Definition Language
    C.
    Storage Definition Localisation
    D.
    Storage Discrete Localisation

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. Which of the following is the process of selecting the data storage and data access characteristics of the database?
  16. A.
    Logical database design
    B.
    Physical database design
    C.
    Testing and performance tuning
    D.
    Evaluation and selecting

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Which of the following is the oldest database model?
  18. A.
    Relational
    B.
    Hierarchical
    C.
    Physical
    D.
    Network

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. The process of saving information onto secondary storage devices is referred to as
  20. A.
    Backing up
    B.
    Restoring
    C.
    Writing
    D.
    Reading

    View Answer

    Workspace

    Discuss Discuss in Forum