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
51. Which of the following file is created by extracting data to prepare a report?
- report file
- master file
- transaction file
- all of these
52. DASD stands for:
- Discrete Application Scanning Devices
- Double Amplification Switching Devices
- Direct Access Storage Devices
- None of these
53. Advantages of Secondary storage devices are:
- economy
- security
- capacity
- all of these
54. Employee ID, Supplier ID, Model No and so on are examples of:
- primary keys
- fileds
- unique record identifier
- all of these
55. Which of the following is DASD ?
- magnetic tape
- magnetic disk
- zip disk
- DAT Cartridge.
56. Which of the following is sequential access storage device?
- hard disks
- magnetic tape
- jaz disk
- floppy disk.
57. In primary data storage area:
- records are written when an indexed-sequential file is originally created
- record are written by the user's programs
- records are written in data blocks in ascending key sequence
- all of these.
58. Which storage media does not permit a record to be read and written in the same place?
- magnetic disk
- hard disk
- magnetic tape
- none of these
59. Data transfer rate is the time:
- from when a read or write request is issued to when data transfer begins
- amount of time required to transfer data from the disk to or from main memory
- required to electronically activate the read/write head over the disk surface where data transfer is to take place
- none of these
60. Optical storage is a:
- high-speed direct access storage device
- low-speed direct access storage device
- medium-speed direct access storage device
- high-speed sequential access storage device.