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
You want to use a perspective in an mdx query. How do you select the perspective?
 Explain what is sql override for a source taLle in a mapping?
How many triggers are possible per table?
How to access the deleted record of an event?
What is tabulation?
how many type of indexing in database?
Tell me what are cursors and when they are useful?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Can sql servers link to other servers?
what are the disadvantages of cursors? : Sql server database administration
Write a program to fetch first 10 records from a file?
How do you delete duplicate rows in sql server?
We need to perform what steps in the following order to work with a cursor?
What is view in sql?
How important do you consider cursors or while loops for a transactional database?