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 to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1101

---

What is difference between order by and group by?

1006

---

What is the difference between char and varchar2 datatype in sql?

1066

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1107

---

What is sql stored procedure?

1093

---

Write a SQL query in order to merge two different columns into single column?

1036

---

Does view occupy space?

944

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

980

---

How do I delete a sql server database?

1044

---

A trigger can reference objects outside the current database? State true or false.

1008

---

How to create a simple user defined function in ms sql server?

1021

---

How to manipulate data from one table to another table ?

969

---

Explain user defined functions?

994

---

What are different types of constraints?

922

---

What is the advantage of sql server?

1034

---