Answer Posted / babu

RIAD: Redundant Array of Inexpensive Disks...
and definition is logically grouping for physically disks to achieving the better performance and fault tolerance.
In This RAID two types :1)Hardware RAID 2)Software RAID and also RAID levels...
RAID Levels:
============
1)RAID 0:we have minimum two drives.it is called as "Data striping".In this disk to better performance but main default is no redundancy..If one disk have fail the total data as loss...

2)RAID 1:we have minimum 2 drives. it is called as "Data Mirroring".In this disk very high performance and redundancy but duplicate data drive or waste is very high...

3)RAID 3:it is called as "Striping with dedicated parity".

What is the difference between join and inner join?

1012

---

Does the order of columns in update statements matter?

913

---

What is the ‘fillfactor’?

968

---

Is it important for a database administrator to understand the operating system and file access?

982

---

What is reportserver and reportservertempdb ?

152

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1145

---

A trigger can reference objects outside the current database? State true or false.

1004

---

What is cursors?

1178

---

Can you move the resources after pausing the node? : sql server database administration

1102

---

How to turn off warning messages during php execution?

1044

---

Explain different backup plans?

940

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

955

---

What are user defined functions in ms sql server?

997

---

Mention the differences between local and global temporary tables.

1041

---

Explain throw statement in sql server 2008?

989

---