.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Ava Aiden
Imran Ghani
Thomas Shaw

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

What advantage does a transaction have over a batch or script?

Posted By :Ravi Ranjan Kumar     Posted Date :July 24, 2011    Points :40   Category :Sql Server 
In short A transaction executes as a single unit of work. If a transaction fails, it can be rolled back as a unit, leaving data in a consistent state.

You can also find related Interview Question to What advantage does a transaction have over a batch or script?  below: 

What's the advantage of using System.Text.StringBuilder over System.String?

StringBuilder is more efficient in the cases, where a lot of manipulation is done to the text. Strings are immutable, so each time it's being operated on, a new instance is created. (More...)

Which property needs to be set for script manager control to extend the time before throwing time out expection if no response is received from the server?

AsyncPostBackTimeout Property needs to set which gets or sets a value that indicates the time, in seconds, before asynchronous postback time out if no response is received from the server.

The default value of this property is 90 second. We can also set the user defined error message using asyncpostbackerrormessage property (as shown in above code) for time out. (More...)

How to add a combo box dynamically at run time in Java script?

document.forms[0]..options[index] new Option("Add text Value") (More...)

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user. (More...)

Advantage of Single Node Topology?

1. Easy to install, configure and manage

2. Least expensive

3. Single cable is required (More...)

Advantage of Bus topology?

1. Installation of devices is easy

2. Requires less cable compared to star topology

3. Less expensive and works better for smaller networks (More...)

Advantage Star Topology?

1. Easy to install, configure, manage and expand

2. Centralized management

3. Addition or removal of device does not affect the whole network (More...)

Advantage of Ring Topology?

1. Data travels at greater speed.

2. No collisions.

3. Handles large volume of traffic. (More...)

Advantage of Mesh Topology?

1. Improves fault tolerance.

2. Failure of one link does not affect entire network.

3. Centralized management is not required. (More...)

Advantage of Tree Topology?

1. Easy to add new devices.

2. Point-to-point wiring for each device.

3. Fault detection is easy. (More...)

How can we cancel a transaction?


Name of the task that is used to execute batch file in SSIS package?

Execute Process Task is used to execute batch files. (More...)

What the different between "Script declared in head section" and "Script declared in body Section"

Script declared in Head Section, Page Loading time the script was executed. you call the script explicitly then only use of this script.
Script declared in Body section, it execute the time of body section load. (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend