Database Questions and Answers – Storage Structure

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

Answer: a
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

Answer: b
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

Answer: c
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.
advertisement
advertisement

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

Answer: a
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

Answer: d
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

Answer: a
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

Answer: b
Explanation: It specifies internal schema and also mapping between two schemas.
advertisement

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

Answer: b
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

Answer: d
Explanation: Network model has data stored in a hierarchical network flow.
advertisement

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

Answer: c
Explanation: The information is written into the secondary storage device.

Sanfoundry Global Education & Learning Series – Database Management System.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.