This set of Database Multiple Choice Questions & Answers (MCQs) focuses 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: 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
View Answer
Explanation: Hierarchical database model was developed by IBM in the early 1960s.
10. The process of saving information onto secondary storage devices is referred to as
a) Backing up
b) Restoring
c) Writing
d) Reading
View Answer
Explanation: The information is written into the secondary storage device.
Sanfoundry Global Education & Learning Series – Database Management System.
- Check DBMS Books
- Check Computer Science Books
- Apply for Computer Science Internship
- Check Programming Books
- Practice RDBMS MCQ
