Skip to content
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
- Hierarchical model MCQs in DBMS
- Network model MCQs in DBMS
- Relational model MCQs in DBMS
- Object-oriented model MCQs in DBMS
- NoSQL databases MCQs in DBMS
- Relational Database Model MCQs in DBMS
- tables, attributes, tuples, and relations MCQs in DBMS
- Primary keys and foreign keys MCQs in DBMS
- Integrity constraints MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Data Definition Language (DDL) MCQs in DBMS
- Data Manipulation Language (DML) MCQs in DBMS
- Data Control Language (DCL) MCQs in DBMS
- Transaction Control Language (TCL) MCQs in DBMS
- Advanced SQL queries and functions MCQs in DBMS
- Database Design MCQs in DBMS
- Entity-Relationship (ER) modeling MCQs in DBMS
- Extended ER modeling MCQs in DBMS
- Normalization and normal forms (1NF, 2NF, 3NF, BCNF) MCQs in DBMS
- Denormalization MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Three-schema architecture (external, conceptual, internal) MCQs in DBMS
- Data independence MCQs in DBMS
- DBMS components and functions MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Data storage on physical media MCQs in DBMS
- File organization and access methods MCQs
- Indexing (B-trees, hash indexing) MCQs in DBMS
- RAID technology MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- ACID properties (Atomicity, Consistency, Isolation, Durability) MCQs in DBMS
- Transaction states and lifecycle MCQs in DBMS
- Concurrency control techniques (locking, timestamping, multiversion) MCQs in DBMS
- Deadlock detection and resolution MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Authentication and authorization mechanisms MCQs in DBMS
- Data encryption techniques MCQs in DBMS
- Role-based access control MCQs in DBMS
- SQL injection prevention MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Backup types and strategies MCQs in DBMS
- Recovery techniques (log-based, shadow paging) MCQs in DBMS
- Disaster recovery planning MCQs in DBMS
- Distributed Databases MCQs in DBMS
- Distributed database architecture MCQs MCQs in DBMS
- Data fragmentation, replication, and allocation in DBMS
- Distributed query processing MCQs in DBMS
- Consistency models and protocols 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
All Copyrights Reserved 2025 Reserved by T4Tutorials