Storage and File Structure MCQs in DBMS

15 min
Score: 0
Attempted: 0/15
Subscribe

1. Which of the following is the lowest level of abstraction in a DBMS?
(A) Physical Level
(B) Logical Level
(C) View Level
(D) Schema Level

2. In DBMS, the physical storage medium used for storing the database is typically:
(A) RAM
(B) ROM
(C) Hard Disk
(D) Cache Memory

3. The primary purpose of indexing in a database is to:
(A) Decrease storage space
(B) Improve query performance
(C) Reduce data redundancy
(D) Increase data security

4. Which of the following is a type of database index?
(A) Primary Index
(B) Secondary Index
(C) Clustered Index
(D) All of the above

5. A B-tree is primarily used for:
(A) Managing memory
(B) Storing data in a hierarchical form
(C) Optimizing search queries
(D) Reducing data redundancy

6. In DBMS, the storage unit that can read and write data on a magnetic disk is called:
(A) Disk Block
(B) Sector
(C) Disk Drive
(D) Track

7. Which file organization method ensures that related records are stored together in sequential order?
(A) Heap File Organization
(B) Sequential File Organization
(C) Hash File Organization
(D) Clustered File Organization

8. The technique used to improve the performance of database systems by minimizing the amount of data read from storage is known as:
(A) Normalization
(B) Caching
(C) Indexing
(D) Denormalization

9. Which of the following is true about the primary index in a database?
(A) It is created on a non-key attribute
(B) It can be sparse or dense
(C) It is always dense
(D) It is only used for large databases

10. In a database, what is the purpose of a RAID (Redundant Array of Independent Disks) system?
(A) To increase data redundancy
(B) To improve storage efficiency
(C) To enhance data reliability and performance
(D) To simplify database management

11. Which of the following storage types provides the fastest data access speed?
(A) SSD (Solid State Drive)
(B) HDD (Hard Disk Drive)
(C) Tape Storage
(D) Optical Disks

12. Which of the following is not a characteristic of a B+ tree?
(A) All leaf nodes are at the same level
(B) Leaf nodes are linked
(C) It uses binary search at each level
(D) Each node has only one child

13. In a DBMS, a block is:
(A) The smallest unit of data that can be read or written
(B) A logical unit of storage
(C) Used to speed up the query processing
(D) A type of data redundancy

14. The purpose of a hash function in a hash file organization is to:
(A) Distribute data uniformly across the storage space
(B) Compress the data to save space
(C) Encrypt the data for security
(D) Create a secondary index

15. In DBMS, fragmentation is a technique used to:
(A) Divide a database into smaller pieces for distribution
(B) Merge smaller databases into one large database
(C) Create backups of the database
(D) Encrypt the database for security