Answer Posted / sonu

A transaction is a sequence of sql Operations,
work as single atomic unit of work. To be qualify
as a "Transaction" , this sequence of operations must satisfy 4 properties , which is knwon as ACID test.any database must follow these acid properties.

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

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

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

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

How are the exceptions handled in sql server programming?

1119

---

What were the latest updates to SQL Azure service?

113

---

What is difference between foreign key and unique key?

1051

---

Explain can SSRS reports Cache results?

161

---

Explain stored procedure?

1110

---

What do you understand by triggers?

980

---

Mention what are the different types of ssrs reports?

158

---

What is the name of reporting services config file and what’s it’s used for?

153

---

What do you understand by coalesce in sql server?

1129

---

Write a sql query to sort on different column name according to the parameters passed in the function?

964

---

Why I have to use stored procedures?

1096

---

Explain the steps needed to create a scheduled job?

983

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1942

---

What different steps will a sql server developer take to secure sql server?

1040

---

What is an indexing strategy?

1072

---