Answer / Ashok Kumar Swarup

RAID (Redundant Array of Inexpensive Disks) is a method of storing data on multiple disks for increased performance and redundancy. RAID can influence database performance in several ways:n1. Increased read and write speed: RAID 0, also known as striping, writes the same data across multiple disks simultaneously, increasing read and write speed.n2. Data availability: RAID 1, mirroring, maintains a duplicate of all data on separate disks, ensuring that data is still accessible if one drive fails.n3. Fault tolerance: Other RAID levels (RAID 5, RAID 6) provide parity information to recover data in case of drive failure.n4. Wear leveling: Distributing write operations across all disks in a RAID array can help prevent individual drives from wearing out too quickly.

Define primary key?

1 Answers  

---

What are the advantages of using cte?

1 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 Answers  

---

select empid empname from employee What is the result for the about query?

4 Answers  

---

Explain nested trigger in sql?

1 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

what are defaults? : Sql server database administration

1 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

How to delete existing triggers using "drop trigger"?

1 Answers  

---

Does a server store data?

1 Answers  

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---