Answer / samba shiva reddy . m

One-to-One relationship can be implemented as a single table and rarely as two tables with primary and foreign key relationships.
One-to-Many relationships are implemented by splitting the data into two tables with primary key and foreign key relationships.
Many-to-Many relationships are implemented using a junction table with the keys from both the tables forming the composite primary key of the junction table.

Answer / laxman

using junction table

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

---

Does full backup break log chain?

0 Answers  

---

What is the command used to get the version of sql server?

1 Answers  

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

What is purpose of normalization?

0 Answers  

---

Can binary strings be converted into numeric or float data types?

0 Answers  

---

Explain sql server authentication modes?

0 Answers  

---