Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. The primary medium for the long-term online storage of data is the where the entire database is stored on magnetic disk.
a. semiconductor memory
b. magnetic disks
c. compact disks
d. magnetic tapes
Q. Optical disk systems contain a few drives and numerous disks that can be loaded into one of the drives automatically (by a robot arm) on demand.
a. tape storage
b. jukebox
c. flash memory
d. all of the mentioned
Q. There are “record-once” versions of the compact disk and digital video disk, which can be written only once; such disks are also called disks.
a. write-once, read-many (worm)
b. cd-r
c. dvd-w
d. cd-rom
Q. In magnetic disk stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material.
a. read–write head
b. read-assemble head
c. head–disk assemblies
d. disk arm
Q. A is the smallest unit of information that can be read from or written to the disk.
a. track
b. spindle
c. sector
d. platter
Q. The disk controller uses at each sector to ensure that the data is not corrupted on data retrieval.
a. checksum
b. unit drive
c. read disk
d. readsum
Q. is the time from when a read or write request is issued to when data transfer begins.
a. access time
b. average seek time
c. seek time
d. rotational latency time
Q. The time for repositioning the arm is called the and it increases with the distance that the arm must move.
a. access time
b. average seek time
c. seek time
d. rotational latency time
Q. is around one-half of the maximum seek time.
a. access time
b. average seek time
c. seek time
d. rotational latency time
Q. With multiple disks, we can improve the transfer rate as well by data across multiple disks.
a. striping
b. dividing
c. mirroring
d. dividing
Q. partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.
a. block interleaved parity
b. block interleaved distributed parity
c. bit parity
d. bit interleaved parity
Q. The RAID level which mirroring is done along with stripping is
a. raid 1+0
b. raid 0
c. raid 2
d. both raid 1+0 and raid 0
Q. Tertiary storage is built with :
a. a lot of money
b. unremovable media
c. removable media
d. secondary storage