What is a transactions?



What is a transactions?..

Answer / Singh Pritam Jitendra

A 'transaction' in SQL Server is a logical unit of work that consists of one or more SQL statements. Transactions ensure data consistency by either committing all changes to the database if successful, or rolling back all changes if an error occurs.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is 2nf example?

1 Answers  


Can I delete event logs?

1 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


What is meant by datasource?

1 Answers  


Is sql different from sql server?

1 Answers  


What is the stored procedure?

1 Answers  


Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  


What are the advantages of policy management?

1 Answers  


What is a scheduled job or what is a scheduled task?

0 Answers  


What is the datatype of rowid?

1 Answers  


What is policy management?

1 Answers  


What are types of subqueries?

1 Answers  


Categories