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
11. The term non-volatile means it stores are retains the programs and data even after the computer is switch off.
- TRUE
- FALSE
12. Auxiliary storage devices are also useful for transferring data from ne computer to another.
- TRUE
- FALSE
13. Transaction files contain relatively permanent information about entitites.
- TRUE
- FALSE
14. Master file is a collection of records describingctivities or transactions by organization.
- TRUE
- FALSE
15. Report file is a file created by extracting data to prepare a report.
- TRUE
- FALSE
16. Report file is a file created by extracting data faster than main memory.
- TRUE
- FALSE
17. Report file is a file created by extracting data faster than main memory.
- TRUE
- FALSE
18. The capacity of secondary storage devices is practically unlimited.
- TRUE
- FALSE
19. It is more economical to store data on secondary storage devices than in primary storage devices.
- TRUE
- FALSE
20. Delete operation delete the current record and updates the file on the disk to reflect the deletion.
- TRUE
- FALSE