Database Management System MCQs
749+ questions with answers
The _________ is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.
Which of the following stores several gigabytes of data but usually lost when power failure?
The flash memory storage used are
__________ is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
Which is the cheapest memory device in terms of costs/ bit?
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.
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.
Tape storage is referred to as __________ storage.
In magnetic disk ________ stores information on a sector magnetically as reversals of the direction of magnetization of the magnetic material.
A __________ is the smallest unit of information that can be read from or written to the disk.
The disk platters mounted on a spindle and the heads mounted on a disk arm are together known as ___________
The disk controller uses ________ at each sector to ensure that the data is not corrupted on data retrieval.
_________ is the time from when a read or write request is issued to when data transfer begins.
The time for repositioning the arm is called the ________ and it increases with the distance that the arm must move.
Once the head has reached the desired track, the time spent waiting for the sector to be accessed to appear under the head is called the _______________
In Flash memory, the erase operation can be performed on a number of pages, called an _______ at once, and takes about 1 to 2 milliseconds.
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.
Which level of RAID refers to disk mirroring with block striping?
Optical disk technology uses
With multiple disks, we can improve the transfer rate as well by ___________ data across multiple disks.
Which one of the following is a Stripping technique?
The RAID level which mirroring is done along with stripping is
Where performance and reliability are both important, RAID level ____ is used.
Hardware RAID implementations permit _________ that is, faulty disks can be removed and replaced by new ones without turning power off.
___________ is popular for applications such as storage of log files in a database system since it offers the best write performance.
______________ 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.
Tertiary storage is built with :
Operating system is responsible for
A typical tape drive is ________ a typical disk drive.
During recovery from a failure
A magneto-optic disk is :
Which of the following are the process of selecting the data storage and data access characteristics of the database?
Which of the following is the oldest database model?
The surface area of a tape is ________ the surface area of a disk.
Which one of the following is not a secondary storage?
Which level of RAID refers to disk mirroring with block striping?
A unit of storage that can store one or more records in a hash file organization is denoted as
The file organization which allows us to read records that would satisfy the join condition by using one block read is
What are the correct features of a distributed database?
Each tablespace in an Oracle database consists of one or more files called
The management information system (MIS) structure with one main computer system is called a
Choose the RDBMS which supports full fledged client server application development
One approach to standardization storing of data?
The highest level in the hierarchy of data organization is called
If a piece of data is stored in two places in the database, then
An audit trail ___________
Large collection of files are called ____________
Which of the following hardware component is the most important to the operation of a database management system?
Which of the following is not true of the traditional approach to information processing
Which of these is not a feature of Hierarchical model?