Home » MCQs » DBMS MCQs

DBMS Storage System MCQs

DBMS Storage System MCQs: This section contains multiple-choice questions and answers on Storage System in DBMS.
Submitted by Anushree Goswami, on April 29, 2022

1. The data ___ in a database can be viewed in its entirety.

Fetched
Stored
Created
None

Answer: B) Stored

Explanation:

The data stored in a database can be viewed in its entirety.

2. Various storage devices store ___ in the form of data.

Bits
Bytes
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

Various storage devices store bits and bytes in the form of data.

3. How many types of data storage are there?

Answer: B) 3

Explanation:

There are 3 types of data storage.

4. Which of the following is the type of data storage?

Primary
Secondary
Tertiary
All of the above

Answer: D) All of the above

Explanation:

The types of data storage are -

Primary
Secondary
Tertiary

5. Which of the following has the highest speed?

Primary Storage
Secondary Storage
Tertiary Storage
All of the above

Answer: A) Primary Storage

Explanation:

The primary storage has the highest speed.

6. Which of the following has the lowest speed?

Primary Storage
Secondary Storage
Tertiary Storage
All of the above

Answer: C) Tertiary Storage

Explanation:

The tertiary storage has the lowest speed.

7. Data stored in the primary storage can be accessed ___.

Lately
Quickly
Delayed
None

Answer: B) Quickly

Explanation:

Data stored in this area can be accessed quickly.

8. The primary storage is also referred as -

Volatile Storage
Non-volatile Storage
Seamless Storage
None of the above

Answer: A) Volatile Storage

Explanation:

The primary storage is also referred as Volatile Storage.

9. Memory types that use ____ storage do not permanently store data.

Primary
Secondary
Tertiary
None

Answer: A) Primary

Explanation:

Memory types that use primary storage do not permanently store data.

10. A power ___ of the system also results in the loss of data.

Outage
Crash
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

A power outage or crash of the system also results in the loss of data.

11. How many types of primary storage are there?

Answer: A) 2

Explanation:

There are 2 types of primary storage.

12. Which of the following is the type of primary storage?

Main memory
Cache
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

The types of primary storage are -

Main memory
Cache

13. Data that is accessible via the storage medium is processed by the ___.

Cache
Main memory
Both A and B
None of the above

Answer: A) Main memory

Explanation:

Data that is accessible via the storage medium is processed by the main memory.

14. Every instruction a computer machine receives goes into the ___.

Main memory
Cache
Main Memory & Cache
None of the above

Answer: A) Main memory

Explanation:

Every instruction a computer machine receives goes into the main memory.

15. Gigabytes of ____ storage can be stored on a system, but the memory size is also small enough to store the entire database.

Primary
Secondary
Tertiary
None

Answer: A) Primary

Explanation:

Gigabytes of primary storage can be stored on a system, but the memory size is also small enough to store the entire database.

16. In the event of a power outage or other failure, the ____ memory loses its entire contents.

Main
Secondary
Tertiary
None

Answer: A) Main

Explanation:

In the event of a power outage or other failure, the main memory loses its entire contents.

17. Storage media such as cache are ____.

Cheap
Expensive
Average price
None

Answer: B) Expensive

Explanation:

Storage media such as cache are expensive.

18. Cache is the ___ storage media.

Slowest
Fastest
Deadlock
None

Answer: B) Fastest

Explanation:

Cache is the fastest storage media.

19. Cached storage is kept by computer hardware and usually consists of a ___ amount of information.

Big
Small
Average
None

Answer: B) Small

Explanation:

Cached storage is kept by computer hardware and usually consists of a small amount of information.

20. ___ designers keep cache effects in mind as they design algorithms and query processors.

Database
Data structure
Dataset
None

Answer: B) Data structure

Explanation:

Data structure designers keep cache effects in mind as they design algorithms and query processors.

21. What is secondary storage also known as?

Online Storage
Offline Storage
Main Storage
None

Answer: A) Online Storage

Explanation:

Secondary storage is also known as Online Storage.

22. Data is stored in Secondary Storage in order to be ____ available to the user.

Permanently
Temporarily
Consecutively
Simultaneously

Answer: A) Permanently

Explanation:

Data is stored in Secondary Storage in order to be permanently available to the user.

23. ___ cannot corrupt data stored in secondary storage.

Power failures
System crashes
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

Power failures or system crashes cannot corrupt data stored in secondary storage.

24. Secondary storage is also known as -

Online Storage
Non-volatile storage
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

Secondary storage is also known as online storage and non-volatile storage.

25. Which of the following is the secondary storage media?

Flash Memory
Magnetic Disk Storage
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

The secondary storage media are -

Flash Memory
Magnetic Disk Storage

26. Flash memory files are stored on ___- keys, which are connected to a computer through ___ ports.

Answer: A) USB

Explanation:

Flash memory files are stored on USB (Universal Serial Bus) keys, which are connected to a computer through USB ports.

27. Data can be transferred to a computer system using the USB devices, but they have ___ sizes.

Same
Different
Similar
None

Answer: B) Different

Explanation:

Data can be transferred to a computer system using these USB devices, but they have different sizes.

28. Due to a power failure or other factors, it is possible to retrieve the stored data, unlike the ___.

Main memory
Cache
Both A and B
None of the above

Answer: A) Main memory

Explanation:

Due to a power failure or other factors, it is possible to retrieve the stored data, unlike the main memory.

29. Storage of this type is often used for caching frequently accessed data in ___ systems.

Server
Flash
Storage
None

Answer: A) Server

Explanation:

Storage of this type is often used for caching frequently accessed data in server systems.

30. It leads to high performance systems and can be used to store a ___ amount of data than what can be stored in the main memory.

Smaller
Larger
Medium
None

Answer: B) Larger

Explanation:

It leads to high performance systems and can be used to store a larger amount of data than what can be stored in the main memory.

31. Magnetic Disk Storage is also known as -

Offline Storage Media
Online Storage Media
Shuffle Storage Media
Storage Media

Answer: B) Online Storage Media

Explanation:

Magnetic Disk Storage is also known as Online Storage Media.

32. Magnetic disks are used to store data for a ___ period of time.

Short
Long
Average
None

Answer: B) Long

Explanation:

Magnetic disks are used to store data for a long period of time.

33. A/An ___ database can be stored on magnetic disk storage.

Half
Quarter
Entire
None

Answer: C) Entire

Explanation:

An entire database can be stored on magnetic disk storage.

34. The computer system is responsible for providing access to the data on a disk to the main memory.

Main
Secondary
Primary
Tertiary

Answer: A) Main

Explanation:

The computer system is responsible for providing access to the data on a disk to the main memory.

35. Any time the system ____ the data, it should write back the modified data to the disk.

Saves
Manipulates
Adds
Deletes

Answer: B) Manipulates

Explanation:

Any time the system manipulates the data, it should write back the modified data to the disk.

36. ___ have the distinguishing characteristic of not affecting the data in the event of a system crash or failure, but a disk failure can easily damage and destroy the stored data.

Flash Memory
Magnetic Disks
Optical Storage
Tape Storage

Answer: B) Magnetic Disks

Explanation:

Magnetic disks have the distinguishing characteristic of not affecting the data in the event of a system crash or failure, but a disk failure can easily damage and destroy the stored data.

37. There is a type of storage called Tertiary Storage that is ___ to the computer system.

Internal
External
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

There is a type of storage called Tertiary Storage that is external to the computer system.

38. ___ Storage has the slowest speed.

Primary
Secondary
Tertiary
None

Answer: C) Tertiary

Explanation:

Tertiary Storage has the slowest speed.

39. A ____ storage system can store a significant amount of data.

Primary
Secondary
Tertiary
None

Answer: C) Tertiary

Explanation:

A tertiary storage system can store a significant amount of data.

40. Tertiary storage is also known as -

Online storage
Offline storage
Main storage
None

Answer: B) Offline storage

Explanation:

Tertiary Storage is also known as Offline Storage.

41. Data backup usually takes place on ___ storage.

Primary
Secondary
Tertiary
None

Answer: C) Tertiary

Explanation:

Data backup usually takes place on tertiary storage.

42. Which of the following is the tertiary storage device?

Optical Storage
Tape Storage
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

The tertiary storage devices are -

Optical Storage
Tape Storage

43. ____ of data can be stored on optical storage devices.

Megabytes
Gigabytes
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

Megabytes or gigabytes of data can be stored on optical storage devices.

44. In order to store 700 megabytes of data on a Compact Disk (CD), the drive must be played for approximately ___ minutes.

Answer: C) 80

Explanation:

In order to store 700 megabytes of data on a Compact Disk (CD), the drive must be played for approximately 80 minutes.

45. The depth and width of a DVD or Digital Video Disk can store between ____ gigabytes of data.

4.7
8.5
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

The depth and width of a DVD or Digital Video Disk can store between 4.7 and 8.5 gigabytes of data.

46. ___ is the most cost-effective storage medium compared to disks.

Magnetic Disk Storage
Optical Storage
Tape Storage
None of the above

Answer: C) Tape Storage

Explanation:

Tape storage is the most cost-effective storage medium compared to disks.

47. Data is ___ up on tapes.

Archived
Backed
Both A and B
None of the above

Answer: C) Both A and B

Explanation:

Data is archived or backed up on tapes.

48. Data is accessed ___ from the beginning when using Tape Storage because it is accessed ____ from the beginning.

Consecutively
Sequentially
Simultaneously
None

Answer: C) Simultaneously

Explanation:

Data is accessed sequentially from the beginning when using Tape Storage because it is accessed sequentially from the beginning.

49. Tape Storage also refer as -

Sequential-access Storage
Offline Storage
Online Storage
Main Storage

Answer: A) Sequential-access Storage

Explanation:

Tape Storage also refer as Sequential-access Storage.

50. The ability to access data directly from any location on a disk is what makes disk storage known as ___ storage.

Random-access
Direct-access
Linear-access
Heap-access

Answer: B) Direct-access

Explanation:

The ability to access data directly from any location on a disk is what makes disk storage known as direct-access storage.

51. Which among the following comes at the top in storage hierarchy?

Cache
Main Memory
Flash Memory
Magnetic Disk

Answer: A) Cache

Explanation:

Cache comes at the top in storage hierarchy.

52. Which among the following comes at the bottom in storage hierarchy?

Magnetic Disks
Main Memory
Flash Memory
Magnetic Tapes

Answer: D) Magnetic Tapes

Explanation:

Magnetic Tapes comes at the bottom in storage hierarchy.

DBMS Decomposition Algorithms Multiple-Choice Questions

DBMS File Organization Storage Multiple-Choice Questions

Preparation

Aptitude Questions MCQs Find Output Programs

What's New

Top Interview Coding Problems/Challenges!

Comments and Discussions!