Explore topic-wise MCQs in Rdbms.

This section includes 19 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the factors need not be taken into consideration while choosing a RAID level?

A. Monetary cost
B. I/O requirements
C. Performance when the disk has failed
D. None of the mentioned
Answer» E.
Discussion
2.

RAID level 5 refers to?

A. Disk arrays with striping at the level of blocks
B. Disk mirroring with block striping
C. Memory style error correcting code
D. Block interleaved distributed parity
Answer» E.
Discussion
3.

RAID level 2 refers to?

A. Disk arrays with striping at the level of blocks
B. Disk mirroring with block striping
C. Memory style error correcting code
D. Block interleaved distributed parity
Answer» D. Block interleaved distributed parity
Discussion
4.

RAID level 1 refers to?

A. Disk arrays with striping at the level of blocks
B. Disk mirroring with block striping
C. Memory style error correcting code
D. Block interleaved distributed parity
Answer» C. Memory style error correcting code
Discussion
5.

WHICH_OF_THE_FACTORS_NEED_NOT_BE_TAKEN_INTO_CONSIDERATION_WHILE_CHOOSING_A_RAID_LEVEL??$

A. Monetary cost
B. I/O requirements
C. Performance when the disk has failed
D. None of the mentioned
Answer» E.
Discussion
6.

____________IS_POPULAR_FOR_APPLICATIONS_SUCH_AS_STORAGE_OF_LOG_FILES_IN_A_DATABASE_SYSTEM_SINCE_IT_OFFERS_THE_BEST_WRITE_PERFORMANCE.?$

A. RAID level 1
B. RAID level 2
C. RAID level 0
D. RAID level 3
Answer» B. RAID level 2
Discussion
7.

_______________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. RAID level 1
B. RAID level 2
C. RAID level 5
D. RAID level 3
Answer» B. RAID level 2
Discussion
8.

Hardware RAID implementations permit _________ that is, faulty disks can be removed and replaced by new ones without turning power off?

A. Scrapping
B. Swapping
C. Hot swapping
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
9.

______________ partitions data and parity among all N+1 disks, instead of storing data in N-disks and parity in one disk.

A. Block interleaved parity
B. Block interleaved distributed parity
C. Bit parity
D. Bit interleaved parity
Answer» C. Bit parity
Discussion
10.

RAID level 0 refers to?

A. Disk arrays with striping at the level of blocks
B. Disk mirroring with block striping
C. Memory style error correcting code
D. Block interleaved distributed parity
Answer» B. Disk mirroring with block striping
Discussion
11.

The RAID level which mirroring is done along with stripping is

A. RAID 1+0
B. RAID 0
C. RAID 2
D. Both RAID 1+0 and RAID 0
Answer» E.
Discussion
12.

How many levels of RAID exist?

A. 5
B. 6
C. 7
D. 8
Answer» D. 8
Discussion
13.

Which one of the following is a Stripping technique?

A. Byte level stripping
B. Raid level stripping
C. Disk level stripping
D. Block level stripping
Answer» E.
Discussion
14.

Data striping by splitting bits across multiple disks is called as _______

A. RAID striping
B. Array striping
C. Bit level striping
D. Block level striping
Answer» D. Block level striping
Discussion
15.

With multiple disks, we can improve the transfer rate as well by ___________ data across multiple disks.

A. Striping
B. Dividing
C. Mirroring
D. Dividing
Answer» B. Dividing
Discussion
16.

State true or false: Using RAID increases the mean time to failure

A. True
B. False
Answer» B. False
Discussion
17.

Optical disk technology uses

A. Helical scanning
B. DAT
C. A laser beam
D. RAID
Answer» E.
Discussion
18.

The process of duplicating every disk is called _______

A. Incremention
B. Arraying
C. Mirroring
D. Reflecting
Answer» D. Reflecting
Discussion
19.

What is the full form of RAID?

A. Redundant Array of Independent Disks
B. Reliable Array of Independent Disks
C. Redundant Asset Increment Data
D. Reliable Aggravation of Immaculate Data
Answer» B. Reliable Array of Independent Disks
Discussion