A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by

DBMS - STORAGE AND FILE STRUCTURES MCQs

• Disadvantages of File systems to store data is:
• 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
• The storage structure which do not survive system crashes are ______
• Storage devices like tertiary storage , magnetic disk comes under
• For a transaction to be durable, its chaFor a transaction to be durable, its changes need to be written to ________ storage.nges need to be written to ________ storage
• The unit of storage that can store one are more records in a hash file organization are
• A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content
• A file produced by a spreadsheet
• SDL means _____________
• Which of the following is the process of selecting the data storage and data access characteristics of the database
• The process of saving information onto secondary storage devices is referred to as
• The file organization that provides very fast access to any arbitrary record of a file is
• A B-tree of order m has maximum of _____________ children
• If the record management system allows you to edit values before they are recorded on disk, you can
• The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain
• What is the name given to the database management system which is able to handle full text data, image data, audio and video
• To have a file hold a list, it is necessary to
• A large computer information system maintains many different computer files. Which amongst them is called a perpetual file
• A form defines
• The logical data structure with a one-to-many relationship is a
• A computer file contains several records. What does each record contain
• A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file
• Which of the following is a serious problem of file management systems?
• In any hierarchy of data organization, the smallest entity to be processed as a single unit is called
• Two files may be joined into a third file if
• The distinguishable parts of a record are called
• Large collections of files are called
• A computer file can be best described as
• A multiple-form file management system
• The term _____ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types
• A _____ Contains fields of data about one entity
• The activity of a file
• Versatile report generators can provide
• Related fields in a data base are grouped to form
• A file that is organized in uniform format is formally referred to as a _____ or a database file
• A form can be used to
• The storage media that is operated directly from computer's central processing unit is considered as
• The technique which is used to retrieve data from disk in form of continuous blocks of stream and eliminates seek time is classified as
• The reserved area that holds one block in main storage is classified as
• The time period required to transfer blocks in consecutive order is classified as
• The range of capacity for the number of tracks is
• The kind of memories that use an array of platters of CD-ROM must be loaded on demand into the drives are classified as
• The command used in high level programs to transfer the record block in to the main memory buffer is classified as
• The concept in which extra bit or byte is stored for record deletion and that extra stored bit is called
• The storage capacity of computer system is measured in
• The type of memories used in MP3 players and cameras are called
• The memory which loses contents because of power cut is classified as
• Considering storage capacity, the one million bytes of data are equal to
• The DVD devices and CD-ROM are examples of
• The example of computer\'s primary storage is
• The networking system in which the online peripherals of storage are configured as nodes on very high speed network is classified as
• The field on which the equality condition is placed is hashing technique is called
• The command in DBMS in which the all the records existed in the file are retrieved in specific order is classified as
• The hierarchy of computer storage media includes
• Considering the disks, the command with which the block from disk is copied from the specific buffer is classified as
• The time which is needed for consecutive blocks transferring is classified as
• The technique used in DBMS to store all the related objects in the mixed file is classified as
• If the current number of records are 92, blocking factor is 20 and the number of file buckets are 5 then the file load factor is
• The command in high level programming which completes the release of buffers and perform other cleanup operations remaining is classified as
• The example of tertiary storage media is
• The disk units which has an actuator attached into it are called
• Considering the disks, the command with which the buffer is copied into the block of disk is classified as
• The magnetic tapes are examples of
• The storage capacity of digital video disk is
• The combination of track number, block number and cylinder number is classified as
• The file which consists of the ordering fields for records is called
• In the allocation of file blocks on disk, the clusters are also called
• The command which returns the first record of the just opened file is classified as
• Considering the device specifications, the byte sizes are usually from
• The file which consists of ordering attribute which is non key in nature called
• The type of allocation in which blocks of file are allocated to consecutive blocks of disks is classified as
• The hard disk drives are example of
• The process of finding some other position when hash address is occupied is classified as
• The ordered files with primary index are called
• The record searching technique in which the searching of records is done by block by block is classified as
• In the disk packs, the tracks are divided into smaller block of information containing large amount of information called
• In high level programs, the command which is used to prepare the file for writing and reading is classified as
• The technique of writing data on two physical disks and treating both disks as one logical disk unit is classified as
• Considering storage capacity, the one billion bytes of data are equal to
• The circles in a disk in which the information is stored are called
• The files in which the updates are performed rarely are classified as
• If the file load factor is 0.6, blocking factor is 25 and the number of file buckets are 5 then the current number of records are
• If the global depth in extendible hashing is equal to local depth then the operation must be performed in directory array is
• In external hashing for files of disk, the pointers which contain record position and block address within the block are classified as
• The technique which involves the arithmetic function or logical function is classified as
• The temporary unordered file is also called
• In high level programs, the command which is used to copy the current record from buffer to variable of user program is classified as
• In disks, the tracks having same diameter on different surfaces are classified as
• In high level programs, the command which sets the pointer of file to the beginning of that file is classified as
• The time required to position write or read track on correct place is classified as
• Considering storage capacity, the 2000 bytes of data are equal to
• Statements
• What is the difference between flash memory and main memory
• What is the full form of USB?
• DVD is a form of ______ storage
• Which of the following is a part of the Magnetic disk assembly
• When a large number of disks are connected by a high speed network to a number of server computers, it is known as ________ architecture
• The time from when a read or write request is issued to when the actual data transfer begins is called _______
• The time for repositioning the arm is called as _________
• Which of the following is a measure of reliability of a disk
• What is buffering?
• What is an NVRAM
• Files that support log disks are called as ________
• State true or false: NOR flash is cheaper than NAND flash
• The logical to physical page mapping is represented in a ____________
• What is the full form of RAID
• The process of duplicating every disk is called _______
• State true or false: Using RAID increases the mean time to failure
• Data striping by splitting bits across multiple disks is called as _______
• How many levels of RAID exist
• RAID level 0 refers to
• RAID level 1 refers to
• RAID level 2 refers to
• RAID level 5 refers to
• Which of the factors need not be taken into consideration while choosing a RAID level
• What is the approximate storage capacity of CDs in MB
• The devices that store a lot of optical disks are called as
• Which of the following is true about file header
• How can variable length records arise in a file
• What does a null bitmap indicate
• State true or False: Variable length records cannot be implemented
• The linked list formed by the deleted records is called as ______
• The slotted page structure is used for _________
• The header in the slotted page structure does not contain which of the following data
• State true or false: It is easier to delete a record from the fixed length records
• What is heap file organization
• What is sequential file organization
• What is hashing file organization
• What is a search key in sequential file organization
• Metadata about the relations are stored in ________
• Data dictionary is also called as ________
• What is a multitable clustering file organization
• Which of the following need to be stored in the data dictionary
• The subsystem responsible for the allocation of buffer space is called as _______
• What is the full form of LRU (in buffer replacement strategy)
• 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
• The primary medium for the long-term online storage of data is the __________ where the entire database is stored on magnetic disk
• 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 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
• _________ is around one-half of the maximum seek time
• 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
• ______________ partitiones data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk
• Hardware RAID implementations permit _________ that is, faulty disks can be removed and replaced by new ones without turning power off
• ______________ 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
• 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
• 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
• An audit trail ___________
• Large collection of files are called ____________
• Which of the following hardware component is the most important to the operation of 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
• Which of these data models is an extension of relational data model
• The information about data in a database is called _______
• A data dictionary is a special file that contains
• Relational schemas and other metadata about relations are stored in a structure called the ____________
• __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth
• ________ is the smallest unit of allocation in an Oracle database
• An Oracle __________ is a set of tables and views that are used as a read-only reference about the database
• A data dictionary is created when a __________ created
• An Oracle object type has two parts the _________ and__________
• The _______ is that part of main memory available for storage of copies of disk blocks
• A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by
• The subsystem responsible for the allocation of buffer space is called the ___________
• In the buffer where there is no space for another block, the bllock can be inserted using
• A block that is not allowed to be written back to disk is said to be ______________
• There are situations in which it is necessary to write back the block to disk, even though the buffer space that it occupies is not needed. This write is called the
• The frequently used buffer replacement strategy is
• In case the buffer manager do not write the blocks properly then the buffer manager uses
• The technique where the blocks which have been used are replaced is called
• ___________________ frees the space occupied by a block as soon as the final tuple of that block has been processed

This question belongs to these collections

• DBMS - STORAGE AND FILE STRUCTURES MCQs

Similar questions