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?
- 2
- 3
- 4
- 5
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?
- 2
- 3
- 4
- 5
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.
- 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.
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.
- 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.
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.
ADVERTISEMENT
ADVERTISEMENT