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

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

  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

  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

  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

  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

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

  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

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

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