Answer / Prateek Jain

Query processing in a database management system refers to the set of operations that are performed when a user submits a SQL (Structured Query Language) statement or query. The process includes parsing, optimization, and execution phases, with the goal of retrieving the requested data efficiently.

Explain what is lock escalation and what is its purpose?

1 Answers  

---

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

1 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1 Answers  

---

Why use “pivot” in sql server?

1 Answers  

---

what is the purpose of creating view is sql server 2000

13 Answers   Wipro,

---

What is the difference between commit and rollback?

1 Answers  

---

what are the problems in logshipping?

3 Answers  

---

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

---

What are the types of subscriptions in SQL Server replication?

1 Answers   HCL,

---

Explain what are partitioned views and distributed partitioned views?

1 Answers  

---

Can an entity have two primary keys?

1 Answers  

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1 Answers  

---