How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

---

Explain the disadvantages/limitation of the cursor?

0 Answers  

---

What are the pre-defined functions in the sql server?

0 Answers  

---

What is the use of Port no?

1 Answers   Wipro,

---

How to specify the collation for a character data type in ms sql server?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

How do database indexes work?

0 Answers  

---

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

---