Answer Posted / a.ganesh

it's reduce the repeated data in the database
.I think this is main advantage and the recode can't
directly delete from Parent Table

Can we insert data if clustered index is disabled?

685

---

Is a primary key unique?

709

---

How to apply cascading referential integrity in place of triggers?

760

---

What is SQL Azure Fabric?

106

---

Find columns used in stored procedure?

707

---

Create and insert into temp table in sql server?

788

---

What is ms sql server index?

747

---

After removing a table from database, what other related objects have to be dropped explicitly?

802

---

Explain the flow of creating a cube? : sql server analysis services, ssas

809

---

Explain the third normal form(3nf)?

702

---

What is the concept of optimization?

780

---

How can you check the version of sql server?

782

---

What is a partition function in sql server?

707

---

How to truncate the log in sql server 2012? : sql server database administration

792

---

What is the difference between functions and scalar functions?

757

---