DBMS-Physical Data Organization

DBMS-Physical Data Organization
21. A file could be made of records which are of different sizes. These records are called variable-length records.
  • TRUE
  • FALSE
Show Answer
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
Show Answer
23. When using sequential access to reach a particular record, all the records preceding it need not be  processed
  • TRUE
  • FALSE
Show Answer
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
Show Answer
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
Show Answer
26. Auxiliary and secondary storage devices are the same.
  • TRUE
  • FALSE
Show Answer
27. Sequential access storage is off-line
  • TRUE
  • FALSE
Show Answer
28. Magnetic tapes are direct-access media
  • TRUE
  • FALSE
Show Answer
29. Direct access systems do not search the entire file, instead, they move directly to the needed record
  • TRUE
  • FALSE
Show Answer
30. Hashing is a method o determining the physical location of a record
  • TRUE
  • FALSE
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test