MCQs on Storage and File Structure in DBMS
- 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
- Answer: A. Physical Level
- In DBMS, the physical storage medium used for storing the database is typically:
- A. RAM
- B. ROM
- C. Hard Disk
- D. Cache Memory
- Answer: C. Hard Disk
- 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
- Answer: B. Improve query performance
- Which of the following is a type of database index?
- A. Primary Index
- B. Secondary Index
- C. Clustered Index
- D. All of the above
- Answer: D. All of the above
- 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
- Answer: C. Optimizing search queries
- 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
- Answer: C. Disk Drive
- 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
- Answer: B. Sequential File Organization
- 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
- Answer: B. Caching
- 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
- Answer: C. It is always dense
- 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
- Answer: C. To enhance data reliability and performance
- 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
- Answer: A. SSD (Solid State Drive)
- 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
- Answer: D. Each node has only one child
- 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
- Answer: A. The smallest unit of data that can be read or written
- 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
- Answer: A. Distribute data uniformly across the storage space
- 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
- Answer: A. Divide a database into smaller pieces for distribution
More MCQs Of Database Systems
- Database Models MCQs in DBMS
- Relational Database Model MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Database Design MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Distributed Databases MCQs in DBMS
- SET 1: database design mcqs (database design mcqs )
- SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
- SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
- SET 4: database systems mcqs (database systems mcqs)
- SET 5: dbms mcqs (dbms mcqs )
- SET 6: dbms mcqs with answers (dbms mcqs with answers)
- SET 7: solved mcqs of dbms (solved mcqs of dbms)
- SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
- SET 9: relational database management system mcqs(relational database management system mcqs)
- SET 10: solved mcqs of database management system(solved mcqs of database management system)
- SET 11: basic database mcqs pdf (basic database mcqs pdf)
- SET 12: relational database management system mcqs (relational database management system mcqs )
- SET 13: database mcqs online test (database mcqs online test)
- SET 14: database interview questions mcqs (database interview questions mcqs)
- SET 15: database developer mcqs (database developer mcqs)
- SET 16: database Repeated mcqs (database Repeated mcqs)
- SET 17: Database mcqs PPSC (Database mcqs PPSC)
- SET 18: Database mcqs FPSC (Database mcqs FPSC)
- SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)
New Arrival