DBMS-Physical Data Organization Questions and Answers

Take Exam

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

61. Head activation time 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
Show Answer Report

62. Which of the following is a factor that affects the access time of hard disks?

  • rotational delay time
  • data transfer time
  • seek time
  • all of these
Show Answer Report

63. Which is the least expensive secondary storage device?

  • zip disk
  • hard disk
  • magnetic tape
  • none of these
Show Answer Report

64. Which of the following is not a flexible disks?

  • optical disk
  • zip disk
  • hard disk
  • jaz disk.
Show Answer Report

65. Which of the following is not an optical disk?

  • WORM
  • Super disk
  • CD-ROM
  • CD-RW
Show Answer Report

66. WORM stands for:

  • Write Once Read Many
  • Write Optical Read Magnetic
  • Write On Redundant Material
  • None of these
Show Answer Report

67. What is the expansion of ISAM?

  • Indexed Sequential Access Method
  • Internal Storage Access Mechanism
  • Integrated Storage and Management
  • None of these
Show Answer Report

68. What is the expansion o VSAM?

  • Very Stable Adaptive Machine
  • Varying Storage Access Mechanism
  • Virtual Storage Access Method
  • Noneof these
Show Answer Report

69. Which company developed ISAM?

  • DEC
  • IBM
  • COMPAC
  • HP
Show Answer Report

70. Tertiary storage devices are:

  • slowest
  • fastest
  • medium speed
  • none of these
Show Answer Report
Questions and Answers for Competitive Exams Various Entrance Test