DBMS-Physical Data Organization Questions and Answers

Practice Mode
Showing 10 of 72 questions
Q21
A file could be made of records which are of different sizes. These records are called variable-length records.
  • A TRUE
  • B FALSE
Answer: Option A
Q22
Sequential file organisation is most common because it makes effective use of the least expensive secondary storage devices such as magnetic disk.
  • A TRUE
  • B FALSE
Answer: Option A
Q23
When using sequential access to reach a particular record, all the records preceding it need not be  processed
  • A TRUE
  • B FALSE
Answer: Option B
Q24
In direct file processing, on an average, finding one record will require that half of the records in the file be read.
  • A TRUE
  • B FALSE
Answer: Option A
Q25
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.
  • A TRUE
  • B FALSE
Answer: Option A
Q26
Auxiliary and secondary storage devices are the same.
  • A TRUE
  • B FALSE
Answer: Option A
Q27
Sequential access storage is off-line
  • A TRUE
  • B FALSE
Answer: Option A
Q28
Magnetic tapes are direct-access media
  • A TRUE
  • B FALSE
Answer: Option B
Q29
Direct access systems do not search the entire file, instead, they move directly to the needed record
  • A TRUE
  • B FALSE
Answer: Option A
Q30
Hashing is a method o determining the physical location of a record
  • A TRUE
  • B FALSE
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test