Answer Posted / hari

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

Recovery
simple recovery
full recovery
Bulk recovery

what's the difference between delete table and truncate table commands? : Sql server database administration

923

---

What is set nocount on and what is set nocount off?

885

---

What do we have to check in database testing?

969

---

Why is the need for data conversion transformations?

979

---

How to get the definition of a user defined function back?

1003

---

What is a dbms wizard?

971

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

988

---

When we should use and scope of @@identity?

953

---

What should be the fill factor for indexes created on tables? : sql server database administration

1101

---

What is the purpose of the master database?

1052

---

What are the advantages of passing name-value pairs as parameters?

1106

---

Do you know what is a with(nolock)?

1000

---

How to disable stored procedure sql server?

1532

---

How to drop existing indexes in ms sql server?

1015

---

How many categories of functions based their return modes?

1063

---