Answer Posted / sd
Adding to what POO said
Automicity : Group of T-SQL stmts act in a batch .
Consistency : All or none concept.
Isolation: Visibility of resources used in one transaction
to concurrent transactions
Durability : Once changes are commited to database they are
permanent .
| Is This Answer Correct ? | 36 Yes | 37 No |
Post New Answer View All Answers
Why would you use sql agent?
what is sql server? : Sql server database administration
what is database replicaion? : Sql server database administration
What is difference between rownum and rowid?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is resource governor?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Can you type more than one query in the query editor screen at the same time?
What purpose does the model database server?
Why use triggers?
What is the web service used for reporting services?
How each E-R model constructs can be mapped to the relational model?
Define Unique Key?
Explain optimistic and pessimistic concurrency?
how will add additional conditions in sql?