DBMS-Physical Data Organization Questions and Answers
DBMS Physical Data Organization questions with answers are vital for computer science students and aspirants preparing for placement exams by TCS, Infosys, Wipro, and government technical tests. This topic explains how databases store, retrieve, and manage data efficiently using file structures, indexing, and hashing techniques. By practicing these database MCQs, candidates can enhance their understanding of data access mechanisms, record organization, and storage optimization. Each question is designed to test conceptual clarity and practical application, making this an ideal resource for programming and DBMS interview preparation.
DBMS-Physical Data Organization
Showing 10 of
72 questions
1. The efficiency of the computer system greatly depends on how stores data and how fast it can retrieve the data.
- TRUE
- FALSE
2. Because of the high cost and volatile nature of the auxiliary memory, permanent storage of data is done in the main memory.
- TRUE
- FALSE
4. An indexed-sequential file organisation is a direct processing method.
- TRUE
- FALSE
5. In a physical storage, a record has a physical storage location or address associated with it.
- TRUE
- FALSE
6. Access time is the time from when a read or write request is issued, to the time when data transfer begin
- TRUE
- FALSE
7. The file manager is a software that manages the allocation of storage locations and data structure.
- TRUE
- FALSE
8. The different types of iles are master files, report files and transaction files.
- TRUE
- FALSE
9. The secondary devices are volatile whereas the tertiary storage devices are non-volatile.
- TRUE
- FALSE
10. The buffer manager fetches a requested page from disk into a region of main memory called the buffer pool and tells the file manager the location of the requested page.
- TRUE
- FALSE