Answer Posted / naveen

32 nested transaction can possible in sql server

what is a check constraint?

1037

---

Explain what is public role in sql server?

1058

---

What is table constraint?

928

---

What is table-valued sub query?

920

---

What are the disadvantages of primary key and foreign key in SQL?

1047

---

Describe in brief system database.

947

---

what are the reporting service components in SSRS?

151

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

985

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

915

---

What is lookup override?

959

---

What is sql collation?

1136

---

How do you identify a foreign key?

966

---

What do we have to check in database testing?

967

---

Can you explain different types of locks in sql server?

910

---

How does using a separate hard drive for several database objects improves performance right away?

884

---