What is transcation?Plz give One example?

Question Posted / senthilsjc

Answers were Sorted based on User's Feedback

What is transcation?Plz give One example?..

Answer / hari

Transcation is a sequence of operations performed as single
logical unit work .

Atomicity,consistency,isolation, Durabality

Is This Answer Correct ?

5 Yes

2 No

What is transcation?Plz give One example?..

Answer / dev

Transaction is a process to handle cretical situation data
being inserted into table if any error comes into this
picture data will be rollbacked.

Is This Answer Correct ?

0 Yes

1 No

More SQL Server Interview Questions

Explain time data type in sal server 2008?

What is the default port for SQL Server over a firewall?

Does a server store data?

How to list all field names in the result set using mssql_field_name()?

Data table as parameter in sql server?

What are cursors? Name four types of cursors and when each one would be applied?

List some major differences between triggers and stored procedures?

How many cores do I need for sql server 2016?

how would you improve etl (extract, transform, load) throughput?

What are the advantages of user-defined functions over stored procedures in sql server?

What types of integrity are enforced by a foreign-key constraint

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

For more SQL Server Interview Questions Click Here