Answer / monal

RAID: For FUN it is called Redundant Array of INEXPENSIVE
Disks.
In Reality it is called Redundant Array of Independent Disks.
Following 3 are most popular and still in use in different ways.
1. RAID 0: Disk Striping
2. RAID 1: Disk Mirroring
3. RAID 5: Disk Striping with Parity Bit.

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

How to make a replica of existing oracle server to another server?

3 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---