MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 105 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
The technique used in DBMS to store all the related objects in the mixed file is classified as |
| A. | ternary clustering |
| B. | secondary clustering |
| C. | physical clustering |
| D. | primary clustering |
| Answer» D. primary clustering | |
| 52. |
The example of tertiary storage media is |
| A. | magnetic disks |
| B. | optical disks |
| C. | removable media |
| D. | cache memory |
| Answer» D. cache memory | |
| 53. |
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 |
| A. | 0.85 |
| B. | 0.92 |
| C. | 0.35 |
| D. | 0.46 |
| Answer» C. 0.35 | |
| 54. |
Considering the disks, the command with which the block from disk is copied from the specific buffer is classified as |
| A. | paste command |
| B. | cut command |
| C. | write command |
| D. | read command |
| Answer» E. | |
| 55. |
The command in DBMS in which the all the records existed in the file are retrieved in specific order is classified as |
| A. | Find All command |
| B. | Find n |
| C. | Find Ordered command |
| D. | Reorganize command |
| Answer» D. Reorganize command | |
| 56. |
The disk units which has an actuator attached into it are called |
| A. | transfer disks |
| B. | mechanical disks |
| C. | moveable-head disks |
| D. | fixed-head disks |
| Answer» D. fixed-head disks | |
| 57. |
The field on which the equality condition is placed is hashing technique is called |
| A. | hash field |
| B. | cluster filed |
| C. | spanned field |
| D. | sequential field |
| Answer» B. cluster filed | |
| 58. |
The hierarchy of computer storage media includes |
| A. | primary storage |
| B. | tertiary storage |
| C. | index storage |
| D. | both a and b |
| Answer» E. | |
| 59. |
The example of computer's primary storage is |
| A. | tapes |
| B. | main memory |
| C. | optical disk |
| D. | magnetic disc |
| Answer» C. optical disk | |
| 60. |
The storage capacity of computer system is measured in |
| A. | mega bytes |
| B. | kilo bytes |
| C. | tera bytes |
| D. | all of above |
| Answer» C. tera bytes | |
| 61. |
The command used in high level programs to transfer the record block in to the main memory buffer is classified as |
| A. | modify command |
| B. | insert command |
| C. | read command |
| D. | find next command |
| Answer» E. | |
| 62. |
The memory which loses contents because of power cut is classified as |
| A. | volatile memory |
| B. | non volatile memory |
| C. | random access memory |
| D. | tertiary memory |
| Answer» B. non volatile memory | |
| 63. |
The type of memories used in MP3 players and cameras are called |
| A. | memory databases |
| B. | flash memories |
| C. | mass storage |
| D. | main memory |
| Answer» C. mass storage | |
| 64. |
The file which consists of ordering attribute which is non key in nature called |
| A. | sequential file |
| B. | spanned file |
| C. | master file |
| D. | clustered file |
| Answer» E. | |
| 65. |
The DVD devices and CD-ROM are examples of |
| A. | mass storage |
| B. | main memory |
| C. | memory databases |
| D. | flash memories |
| Answer» B. main memory | |
| 66. |
The type of allocation in which blocks of file are allocated to consecutive blocks of disks is classified as |
| A. | indexed allocation |
| B. | header allocation |
| C. | contiguous allocation |
| D. | linked allocation |
| Answer» D. linked allocation | |
| 67. |
The hard disk drives are example of |
| A. | primary storage |
| B. | ternary storage |
| C. | tertiary storage |
| D. | secondary storage |
| Answer» E. | |
| 68. |
The magnetic tapes are examples of |
| A. | random access storage devices |
| B. | sequential access devices |
| C. | inter-block access devices |
| D. | archive storage device |
| Answer» C. inter-block access devices | |
| 69. |
Considering the device specifications, the byte sizes are usually from |
| A. | 2 to 8 bits |
| B. | 8 to 16 bits |
| C. | 4 to 8 bits |
| D. | 2 to 4 bits |
| Answer» D. 2 to 4 bits | |
| 70. |
The storage capacity of digital video disk is |
| A. | 4.5 to 15 GB per disk |
| B. | 4.5 to 20 MB |
| C. | 16 GB |
| D. | 5 to 15 TB |
| Answer» B. 4.5 to 20 MB | |
| 71. |
The command which returns the first record of the just opened file is classified as |
| A. | reorganize command |
| B. | scan command |
| C. | set-at-a-time command |
| D. | insert command |
| Answer» C. set-at-a-time command | |
| 72. |
The combination of track number, block number and cylinder number is classified as |
| A. | hardware address |
| B. | software address |
| C. | data address |
| D. | disk blocks address |
| Answer» B. software address | |
| 73. |
The file which consists of the ordering fields for records is called |
| A. | sequential file |
| B. | ordered file |
| C. | spanned file |
| D. | both a and b |
| Answer» E. | |
| 74. |
In the allocation of file blocks on disk, the clusters are also called |
| A. | indexes |
| B. | file segments |
| C. | extents |
| D. | both b and c |
| Answer» E. | |
| 75. |
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 |
| A. | 95 |
| B. | 65 |
| C. | 75 |
| D. | 85 |
| Answer» D. 85 | |
| 76. |
The process of finding some other position when hash address is occupied is classified as |
| A. | collision resolution |
| B. | address space resolution |
| C. | multiple hashing resolution |
| D. | chaining resolution |
| Answer» B. address space resolution | |
| 77. |
Considering storage capacity, the one billion bytes of data are equal to |
| A. | 1 kilo bytes |
| B. | 1 tera bytes |
| C. | 1 mega bytes |
| D. | 1 gega bytes |
| Answer» E. | |
| 78. |
The circles in a disk in which the information is stored are called |
| A. | track |
| B. | cylinder |
| C. | sector |
| D. | blocks |
| Answer» B. cylinder | |
| 79. |
The ordered files with primary index are called |
| A. | linear spanned file |
| B. | indexed sequential files |
| C. | relative spanned file |
| D. | indexed spanned file |
| Answer» C. relative spanned file | |
| 80. |
The record searching technique in which the searching of records is done by block by block is classified as |
| A. | heap search |
| B. | non linear search |
| C. | linear search |
| D. | relative search |
| Answer» D. relative search | |
| 81. |
There are “record-once” versions of compact disk and digital video disk, which can be written only once; such disks are also called __________ disks. |
| A. | Write-once, read-many (WORM) |
| B. | CD-R |
| C. | DVD-W |
| D. | CD-ROM |
| Answer» B. CD-R | |
| 82. |
The technique of writing data on two physical disks and treating both disks as one logical disk unit is classified as |
| A. | shadowing |
| B. | clustering |
| C. | distributing |
| D. | non shadowing |
| Answer» B. clustering | |
| 83. |
The kind of memories that use an array of platters of CD-ROM must be loaded on demand into the drives are classified as |
| A. | main memory |
| B. | memory databases |
| C. | flash memories |
| D. | optical jukebox memories |
| Answer» E. | |
| 84. |
The concept in which extra bit or byte is stored for record deletion and that extra stored bit is called |
| A. | insertion marker |
| B. | deletion marker |
| C. | modifying marker |
| D. | static marker |
| Answer» C. modifying marker | |
| 85. |
The temporary unordered file is also called |
| A. | overflow file |
| B. | heap file |
| C. | sequential file |
| D. | spanned file |
| Answer» B. heap file | |
| 86. |
In high level programs, the command which is used to prepare the file for writing and reading is classified as |
| A. | modify command |
| B. | open command |
| C. | locate command |
| D. | reset command |
| Answer» C. locate command | |
| 87. |
A B-tree of order m has maximum of _____________ children. |
| A. | m |
| B. | m+1 |
| C. | m-1 |
| D. | m/2 |
| Answer» B. m+1 | |
| 88. |
The files in which the updates are performed rarely are classified as |
| A. | complete files |
| B. | duplicate files |
| C. | dynamic files |
| D. | static files |
| Answer» E. | |
| 89. |
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. |
| A. | Hybrid drivers |
| B. | Disk drivers |
| C. | Hybrid disk drivers |
| D. | All of the mentioned |
| Answer» C. Hybrid disk drivers | |
| 90. |
The networking system in which the online peripherals of storage are configured as nodes on very high speed network is classified as |
| A. | peripheral network |
| B. | storage area networks |
| C. | local area networks |
| D. | wide are network |
| Answer» C. local area networks | |
| 91. |
The command in high level programming which completes the release of buffers and perform other cleanup operations remaining is classified as |
| A. | read command |
| B. | find next command |
| C. | close command |
| D. | insert command |
| Answer» D. insert command | |
| 92. |
Considering storage capacity, the one million bytes of data are equal to |
| A. | 1 kilo bytes |
| B. | 1 tera bytes |
| C. | 1 mega bytes |
| D. | 1 gega bytes |
| Answer» D. 1 gega bytes | |
| 93. |
Files that support log disks are called as ________ |
| A. | Logging file systems |
| B. | Jorte File Systems |
| C. | Journaling File Systems |
| D. | Channelizing File Systems |
| Answer» D. Channelizing File Systems | |
| 94. |
What is an NVRAM? |
| A. | RAM which is non-volatile in nature |
| B. | RAM whose data is not lost during power failures |
| C. | RAM that significantly speeds up data transfers |
| D. | All of the mentioned |
| Answer» E. | |
| 95. |
The slotted page structure is used for _________ |
| A. | Organizing records in a block |
| B. | Organizing blocks in a database |
| C. | Deleting records from a block |
| D. | None of the mentioned |
| Answer» B. Organizing blocks in a database | |
| 96. |
In the disk packs, the tracks are divided into smaller block of information containing large amount of information called |
| A. | blocks |
| B. | cylinder |
| C. | sector |
| D. | all of above |
| Answer» D. all of above | |
| 97. |
Which of the following hardware component is the most important to the operation of database management system? |
| A. | High resolution video display |
| B. | Printer |
| C. | High speed, large capacity disk |
| D. | Mouse |
| Answer» D. Mouse | |
| 98. |
The process of saving information onto secondary storage devices is referred to as |
| A. | Backing up |
| B. | Restoring |
| C. | Writing |
| D. | Reading |
| Answer» D. Reading | |
| 99. |
Storage devices like tertiary storage , magnetic disk comes under |
| A. | Volatile storage |
| B. | Non-volatile storage |
| C. | Stable storage |
| D. | Dynamic storage |
| Answer» C. Stable storage | |
| 100. |
The file organization that provides very fast access to any arbitrary record of a file is |
| A. | Ordered file |
| B. | Unordered file |
| C. | Hashed file |
| D. | B-tree |
| Answer» D. B-tree | |