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.
Q2 | The time for repositioning the arm is called the                  and it increases with the distance that the arm must move.
Q3 |                    is around one-half of the maximum seek 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.
Q5 | Optical disk technology uses
Q6 | With multiple disks, we can improve the transfer rate as well by                        data across multiple disks.
Q7 |                              partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.
Q8 | The RAID level which mirroring is done along with stripping is
Q9 | Where performance and reliability are both important, RAID level          is used.
Q10 |                        is popular for applications such as storage of log files in a database system since it offers the best write performance.
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.
Q12 | Tertiary storage is built with :
Q13 | Operating system is responsible for
Q14 | A typical tape drive is                  a typical disk drive.
Q15 | During recovery from a failure
Q16 | A magneto-optic disk is :
Q17 | Which of the following are the process of selecting the data storage and data access characteristics of the database?
Q18 | The replacement of a bad block generally is not totally automatic because
Q19 | Which of the following is the oldest database model?
Q20 | The surface area of a tape is                  the surface area of a disk.
Q21 | Which one of the following is not a secondary storage?
Q22 | Which level of RAID refers to disk mirroring with block striping?
Q23 | A unit of storage that can store one or more records in a hash file organization is denoted as
Q24 | The file organization which allows us to read records that would satisfy the join condition by using one block read is
Q25 | What are the correct features of a distributed database?