Database Multiple Choice Questions on “Storage Structure”.
1. The storage structure which do not survive system crashes are ______
a) Volatile storage
b) Non-volatile storage
c) Stable storage
d) Dynamic storage
Answer: a
Clarification: Volatile storage, is a computer memory that requires power to maintain the stored information, in other words it needs power to reach the computer memory.
2. Storage devices like tertiary storage, magnetic disk comes under
a) Volatile storage
b) Non-volatile storage
c) Stable storage
d) Dynamic storage
Answer: b
Clarification: Information residing in nonvolatile storage survives system crashes.
3. 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: c
Clarification: 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.
4. The unit of storage that can store one are more records in a hash file organization are
a) Buckets
b) Disk pages
c) Blocks
d) Nodes
Answer: a
Clarification: Buckets are used to store one or more records in a hash file organization.
5. A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
a) Storage
b) Tertiary
c) Secondary
d) Cluster
Answer: d
Clarification: With a cluster file system, the failure of a computer in the cluster does not make the file system unavailable.
6. A file produced by a spreadsheet
a) is generally stored on disk in an ASCII text format
b) can be used as is by the DBMS
c) all of the mentioned
d) none of the mentioned
Answer: a
Clarification: ASCII text format uses the standard text file for the changing the value.
7. SDL means _____________
a) Storage Discrete Language
b) Storage Definition Language
c) Storage Definition Localisation
d) Storage Discrete Localisation
Answer: b
Clarification: It specifies internal schema and also mapping between two schemas.
8. 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: b
Clarification: Physical database design is the process of selecting the data storage and data access characteristics of the database.
9. Which of the following is the oldest database model?
a) Relational
b) Hierarchical
c) Physical
d) Network
Answer: d
Clarification: Network model has data stored in a hierarchical network flow.
10. The process of saving information onto secondary storage devices is referred to as
a) Backing up
b) Restoring
c) Writing
d) Reading
Answer: c
Clarification: The information is written into the secondary storage device.