DBMS-Physical Data Organization Questions and Answers
Practice ModeShowing 10 of 72 questions
Q1
The efficiency of the computer system greatly depends on how stores data and how fast it can retrieve the data.
Answer: Option A
Q2
Because of the high cost and volatile nature of the auxiliary memory, permanent storage of data is done in the main memory.
Answer: Option B
Q3
In a computer, a file is nothing but a series of bytes.
Answer: Option A
Q4
An indexed-sequential file organisation is a direct processing method.
Answer: Option A
Q5
In a physical storage, a record has a physical storage location or address associated with it.
Answer: Option A
Q6
Access time is the time from when a read or write request is issued, to the time when data transfer begin
Answer: Option A
Q7
The file manager is a software that manages the allocation of storage locations and data structure.
Answer: Option A
Q8
The different types of iles are master files, report files and transaction files.
Answer: Option A
Q9
The secondary devices are volatile whereas the tertiary storage devices are non-volatile.
Answer: Option B
Q10
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.
Answer: Option A