Answer Posted / ravina

A transaction is a sequence of sql Operations(commands),
work as single atomic unit of work. To be qualify
as "Transaction" , this sequence of operations must satisfy
4 properties , which is knwon as ACID test.

A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.

C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.

I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.

D(Durability): All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1066

---

Explain primary key, foreign key and unique key?

1024

---

What is the use of set nocount on/off statement?

1143

---

Explain what are page splits? : SQL Server Architecture

1122

---

What is sql server used for?

1101

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2114

---

What are different types of join?

1378

---

can we have a nested transaction? : Sql server database administration

1195

---

Define right outer join in sql server joins?

1112

---

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

994

---

Explain how many types of relationship?

1086

---

Can we perform backup restore operation on tempdb? : sql server database administration

1048

---

What are the instances when triggers are appropriate?

1020

---

What is multi-statement table-value user-defined function?

1056

---

What is db stored procedure?

945

---