What is a "transaction"? Why are they necessary? - A transaction is a group of operations combined into a logical unit of work. Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system BEGIN Trnasaction Commit Transaction - SQL Server Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL SERVER

DETAILS

Question: What is a "transaction"? Why are they necessary?

Answer: A transaction is a group of operations combined into a logical unit of work. Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system

BEGIN Trnasaction

Commit Transaction

Category	SQL Server Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9598 users
Added on	7/25/2011
Views	67432
Rate it!

Question: What is a "transaction"? Why are they necessary?

Answer:

A transaction is a group of operations combined into a logical unit of work. Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system

BEGIN Trnasaction

Commit Transaction
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Explain Normalization and Denormalization with examples.	View Answer
	When do you get constraint violation? What are the types of constraints?	View Answer
	Difference - Primary Key and Aggregate Key	View Answer
	How functional dependency is related to database table design?	View Answer
	What is a "trigger"?	- SQL Server Interview Questions & Answers"> View Answer
	Why can a "group by" or "order by" clause be expensive to process?	- SQL Server Interview Questions & Answers"> View Answer
	What are "HINTS"? What is "index covering" of a query?	query? - SQL Server Interview Questions & Answers"> View Answer
	What is a VIEW? How to get script for a view?	View Answer
	What is SQL*Loader?	View Answer
	Difference between "VARCHAR" and "VARCHAR2" datatypes.	- SQL Server Interview Questions & Answers"> View Answer
	What is the difference among "dropping a table”,” truncating a table" and deleting all records" from a table.	View Answer
	Difference between "ORACLE" and "MICROSOFT ACCESS" databases.	- SQL Server Interview Questions & Answers"> View Answer
	How to create a database link?	View Answer
	What's the use of SQL Profiler?	View Answer
	What is the use of database index (apart from fast searching of records);What is use of composite key ?	View Answer
	What is SQL*Loader? Difference between	View Answer
	What is the maximum value that can be stored for a datetime field?	View Answer
	How to find out duplicate records in sql server.	View Answer
	How many column maximum we can add in one table and how many foreign key maximum we can use in one table	View Answer
	What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Server Interview Questions & Answers - Exam Mode / Learning Mode