Answer / monal

Serialization is highest level of Isolation. Most resource
intensive and slowest isolation level. But because of
serialization isolation level all concurrency issues like
dirty read, repeatable read and phantom read won't occur.

Answer / anil sharma

Serialization means organise data with relations between
tables.Removing duplicate row maintain structured data.

Answer / nixo

Serialization, This is the higest level of Isolation.
When this is on, no dirty reads, no nonrepeatable reads
and no phantom rows.

Mention the different authentication modes in sql server.

0 Answers  

---

How to create an multi-statement table-valued function?

0 Answers  

---

How do I get to sql server configuration manager?

0 Answers  

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

0 Answers  

---

What is clustered primary key?

0 Answers  

---

How do you rebuild an identity column?

0 Answers  

---

What are the difference between primary keys and foreign keys?

0 Answers  

---

Does sql server use t sql?

0 Answers  

---

What is read uncmmited?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---