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
Is resultset an interface?
How many types of cursor type are there?
Can an entity have two primary keys?
Why people hate cursor?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
how to determine the service pack currently installed on sql server? : Sql server database administration
Please differentiate between a local and a global temporary table?
what stored procedure would you use to view lock information? : Sql server administration
What is difference between order by and group by?
Can we hide the definition of a stored procedure from a use?
What is a select query statement in ms sql server?
Explain error handling in ssis?
Mention the differences between having and where clause.
What are different types of replication in sql server?
What are translations and its use? : sql server analysis services, ssas