Answer Posted / pravesh

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.

Explain the third normal form(3nf)?

896

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

915

---

How to how to convert numeric expression data types using the convert() function??

991

---

How to use wildcard characters in like operations in ms sql server?

1065

---

State a few properties of relational databases?

1062

---

What were the latest updates to SQL Azure service?

109

---

What function does a database engine serve in the sql server?

988

---

Where are stored procedures in sql server?

1010

---

What new changes are being made in SQL Server?

1100

---

How to create function with parameter in sql server?

1041

---

What do you mean by a dependent functionality in a build?

1066

---

Explain what is row_number function?

974

---

What are the difference between primary key and unique key? : sql server database administration

894

---

What does the not null constraint do?

1002

---

How to provide default values to function parameters?

1054

---