Answer Posted / hari

Back up is 3 types
Full backup
Differential backup
Transcational log backup

Recovery
simple recovery
full recovery
Bulk recovery

Tell me the difference between clustered and non-clustered index?

519

---

Can primary key be a foreign key?

566

---

What is difference between joins and subqueries?

538

---

How to call stored procedure using http soap?

523

---

What is onf in normalization form?

574

---

---

What is sub-query in sql server?

674

---

What are the difference between clustered and a non-clustered index?

593

---

What are the tools available in market as an alternative to sql server reporting services?

88

---

Explain the properties of sub-query in sql server?

514

---

What happens if strings are casted into wrong code pages in ms sql server?

569

---

What is the default server name for sql server?

641

---

How to insert data into an existing table?

571

---

What is the difference between mysql and mysqli?

584

---

How can we rewrite sub-queries into simple select statements or with joins?

527

---

How to enable/disable indexes?

600

---