DBMS-Physical Data Organization

DBMS-Physical Data Organization
51. Which of the following file is created by extracting data to prepare a report?
  • report file
  • master file
  • transaction file
  • all of these
Show Answer
52. DASD stands for:
  • Discrete Application Scanning Devices
  • Double Amplification Switching Devices
  • Direct Access Storage Devices
  • None of these
Show Answer
53. Advantages of Secondary storage devices are:
  • economy
  • security
  • capacity
  • all of these
Show Answer
54. Employee ID, Supplier ID, Model No and so on are examples of:
  • primary keys
  • fileds
  • unique record identifier
  • all of these
Show Answer
55. Which of the following is DASD ?
  • magnetic tape
  • magnetic disk
  • zip disk
  • DAT Cartridge.
Show Answer
56. Which of the following is sequential access storage device?
  • hard disks
  • magnetic tape
  • jaz disk
  • floppy disk.
Show Answer
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.
Show Answer
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
Show Answer
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
Show Answer
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.
Show Answer
Questions and Answers for Competitive Exams Various Entrance Test