On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 19

Q1 |                    is the time from when a read or write request is issued to when data transfer begins.
  • access time
  • average seek time
  • seek time
  • rotational latency time
Q2 | The time for repositioning the arm is called the                  and it increases with the distance that the arm must move.
  • access time
  • average seek time
  • seek time
  • rotational latency time
Q3 |                    is around one-half of the maximum seek time.
  • access time
  • average seek time
  • seek time
  • rotational latency time
Q4 | Hybrid disk drives are hard-disk systems that combine magnetic storage with a smaller amount of flash memory, which is used as a cache for frequently accessed data.
  • hybrid drivers
  • disk drivers
  • hybrid disk drivers
  • all of the mentioned
Q5 | Optical disk technology uses
  • helical scanning
  • dat
  • a laser beam
  • raid
Q6 | With multiple disks, we can improve the transfer rate as well by                        data across multiple disks.
  • striping
  • dividing
  • mirroring
  • dividing
Q7 |                              partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.
  • block interleaved parity
  • block interleaved distributed parity
  • bit parity
  • bit interleaved parity
Q8 | The RAID level which mirroring is done along with stripping is
  • raid 1+0
  • raid 0
  • raid 2
  • both raid 1+0 and raid 0
Q9 | Where performance and reliability are both important, RAID level          is used.
  • 0
  • 1
  • 2
  • 0+1
Q10 |                        is popular for applications such as storage of log files in a database system since it offers the best write performance.
  • raid level 1
  • raid level 2
  • raid level 0
  • raid level 3
Q11 |                              which increases the number of I/O operations needed to write a single logical block, pays a significant time penalty in terms of write performance.
  • raid level 1
  • raid level 2
  • raid level 5
  • raid level 3
Q12 | Tertiary storage is built with :
  • a lot of money
  • unremovable media
  • removable media
  • secondary storage
Q13 | Operating system is responsible for
  • disk initialization
  • booting from disk
  • bad-bock recovery
  • all of the mentioned
Q14 | A typical tape drive is                  a typical disk drive.
  • more expensive than
  • cheaper than
  • of the same cost as
  • none of the mentioned
Q15 | During recovery from a failure
  • each pair of physical block is examined
  • specified pair of physical block is examined
  • first pair of physical block is examined
  • none of the mentioned
Q16 | A magneto-optic disk is :
  • primary storage
  • secondary storage
  • tertiary storage
  • none of the mentioned
Q17 | Which of the following are the process of selecting the data storage and data access characteristics of the database?
  • logical database design
  • physical database design
  • testing and performance tuning
  • evaluation and selecting
Q18 | The replacement of a bad block generally is not totally automatic because
  • data in bad block cannot be replaced
  • data in bad block is usually lost
  • bad block does not contain any data
  • none of the mentioned
Q19 | Which of the following is the oldest database model?
  • relational
  • hierarchical
  • physical
  • network
Q20 | The surface area of a tape is                  the surface area of a disk.
  • much lesser than
  • much larger than
  • equal to
  • none of the mentioned
Q21 | Which one of the following is not a secondary storage?
  • magnetic disks
  • magnetic tapes
  • ram
  • none of the mentioned
Q22 | Which level of RAID refers to disk mirroring with block striping?
  • raid level 1
  • raid level 2
  • raid level 0
  • raid level 3
Q23 | A unit of storage that can store one or more records in a hash file organization is denoted as
  • buckets
  • disk pages
  • blocks
  • nodes
Q24 | The file organization which allows us to read records that would satisfy the join condition by using one block read is
  • heap file organization
  • sequential file organization
  • clustering file organization
  • hash file organization
Q25 | What are the correct features of a distributed database?
  • is always connected to the internet
  • always requires more than three machines
  • users see the data in one global schema.
  • have to specify the physical location of the data when an update is done