Answer Posted / hari

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

Recovery
simple recovery
full recovery
Bulk recovery

What is the difference between a fill factor of 100 and 0?

989

---

Why use view instead of a table?

957

---

Why use sub query in sql server and list out types of sub queries?

1004

---

Explain different types of lock modes in sql server 2000?

940

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1063

---

Can we shrink data file in sql server?

1061

---

How to add an address record into adventureworkslt?

991

---

Can group by be used without aggregate functions?

929

---

How can you fetch alternate records from a table?

969

---

What is schemabinding a view?

926

---

What do you understand by sql server agent?

983

---

Explain the use of containers in ssis?

969

---

What is a group function explain with an example?

995

---

Differentiate between a local and a global temporary table?

965

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

1071

---