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.
Discuss this Question
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.
Discuss this Question
3. How many types of data storage are there?
- 2
- 3
- 4
- 5
Answer: B) 3
Explanation:
There are 3 types of data storage.
Discuss this Question
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
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
11. How many types of primary storage are there?
- 2
- 3
- 4
- 5
Answer: A) 2
Explanation:
There are 2 types of primary storage.
Discuss this Question
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
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
17. Storage media such as cache are ____.
- Cheap
- Expensive
- Average price
- None
Answer: B) Expensive
Explanation:
Storage media such as cache are expensive.
Discuss this Question
18. Cache is the ___ storage media.
- Slowest
- Fastest
- Deadlock
- None
Answer: B) Fastest
Explanation:
Cache is the fastest storage media.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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
Discuss this Question
26. Flash memory files are stored on ___- keys, which are connected to a computer through ___ ports.
- USB
- UBS
- BUS
- SUB
Answer: A) USB
Explanation:
Flash memory files are stored on USB (Universal Serial Bus) keys, which are connected to a computer through USB ports.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
38. ___ Storage has the slowest speed.
- Primary
- Secondary
- Tertiary
- None
Answer: C) Tertiary
Explanation:
Tertiary Storage has the slowest speed.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
41. Data backup usually takes place on ___ storage.
- Primary
- Secondary
- Tertiary
- None
Answer: C) Tertiary
Explanation:
Data backup usually takes place on tertiary storage.
Discuss this Question
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
Discuss this Question
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.
Discuss this Question
44. In order to store 700 megabytes of data on a Compact Disk (CD), the drive must be played for approximately ___ minutes.
- 60
- 70
- 80
- 90
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question
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.
Discuss this Question