SQL CASE statement - Introduction and syntax

The answers to following questions will be made available soon. Keep visiting.

Explain the SQL CASE statement. Write SQL syntax for the SQL CASE statement along with an example

SQL Server architecture - Interview questions SQL Server architecture

What is RAID and what are different types of RAID configurations?

RAID stands for Redundant Array of Independent Disks. RAID defines data storage schemes to divide and replicate data among various disks so that data reliability and I/O performance can be increased.

The basic configurations of RAID are:

LEVEL 0 : Striped set without parity/Non-Redundant Array
LEVEL 1 : Mirrored set without parity
LEVEL 2 : Redundancy through Hamming code
LEVEL 3 : Striped set with dedicated parity/Bit interleaved parity
LEVEL 4 : Block level parity
LEVEL 5 : Striped set with distributed parity
LEVEL 6 : Striped set with dual distributed Parity