Database Management System Set 19
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
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