Storage Structure - DBMS

1.

Storage devices like tertiary storage, magnetic disk comes under

   A.) Volatile storage
   B.) Non-volatile storage
   C.) Stable storage
   D.) Dynamic storage

Answer: Option 'B'

​Non-volatile storage

2.

For a transaction to be durable, its changes need to be written to ________ storage.

   A.) Volatile storage
   B.) Non-volatile storage
   C.) Stable storage
   D.) Dynamic storage

Answer: Option 'C'

Similarly, for a transaction to be atomic, log records need to be written to stable storage before any changes are made to the database on disk.

3.

Which of the following is the oldest database model?

   A.) Relational
   B.) Physical
   C.) Network
   D.) Hierarchical

Answer: Option 'C'

Network model has data stored in a hierarchical network flow.

4.

SDL means _____________

   A.) Storage Discrete Language
   B.) Storage Discrete Language
   C.) Storage Definition Localisation
   D.) Storage Discrete Localisation

Answer: Option 'B'

Storage Discrete Language

5.

Which of the following are the process of selecting the data storage and data access characteristics of the database?

   A.) Logical database design
   B.) Physical database design
   C.) Testing and performance tuning
   D.) Evaluation and selecting

Answer: Option 'B'

Physical database design is the process of selecting the data storage and data access characteristics of the database.

Storage Structure - DBMS Download Pdf