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
21. A file could be made of records which are of different sizes. These records are called variable-length records.
- TRUE
- FALSE
22. Sequential file organisation is most common because it makes effective use of the least expensive secondary storage devices such as magnetic disk.
- TRUE
- FALSE
23. When using sequential access to reach a particular record, all the records preceding it need not be processed
- TRUE
- FALSE
24. In direct file processing, on an average, finding one record will require that half of the records in the file be read.
- TRUE
- FALSE
25. In a direct file, the data may be organised in such a way that they are scattered throughout the disk in what may appear to be random in order.
- TRUE
- FALSE
29. Direct access systems do not search the entire file, instead, they move directly to the needed record
- TRUE
- FALSE
30. Hashing is a method o determining the physical location of a record
- TRUE
- FALSE