What is a transaction and what are ACID properties?

Answer Posted / rahul

transaction is only the reading or writing or both reading
and writing in a database. when we are reading from a
database that is transaction where the database is not
changing. in writing into database the database values can
be changed. we can do both reading and writing in a database.
to do these operations the database must have the acid
properties.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is normalization and what are the advantages of it?

707


How to transfer a table from one schema to another?

742


What are the steps you should follow to start sql server in single-user mode?

672


What are the features of Embedded SQL

857


Explain sql server service broker?

702






Explain differentiate between a having clause and a where clause?

682


What is sql or structured query language?

867


State the difference between union and union all?

682


What is the ‘fillfactor’?

729


Do you know what is fill factor and pad index?

746


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

854


What is a subquery in a select query statement in ms sql server?

805


What command do we use to rename a db, a table and a column?

664


How the authentication mode can be changed?

846


Is BCNF better than 2NF & 3NF? Why?

801