Write a query to find 5th highest amount paid from the customer table.

948

---

What do you understand by physical_only option in dbcc checkdb?

995

---

What are the differences between substr and charindex in sql server.

1130

---

What are relationships and mention different types of relationships in the dbms

977

---

What do you understand by integration services in sql server?

972

---

What is single-user mode?

954

---

What are the differences between ms sql server & oracle?

1072

---

What part does database design plays a role in performance of an sql server-based application?

997

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

964

---

What is the command dbcc checkdb used for?

1028

---

Can you name a few encryption mechanisms in sql server?

961

---

What are subqueries in sql server?

1138

---

What is the purpose of update statistics and scope_identity() function?

1115

---

what do you understand by change data capture?

1043

---

Mention the different types of triggers?

1139

---