What is a transaction and what are ACID properties?
Answer Posted / piyush
transaction is a set of operation or activities which are
executed in a logical unit of work which is know as transaction.
ACID
A-Atomicity
C-Consistency
I-Isolation
D-Durability
| Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Explain full-text query in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the difference between mysql and sql server?
What do you understand by coalesce in sql server?
What are different types of subquery?
How to enter binary string literals in ms sql server?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is query optimization process?
Explain some stored procedure creating best practices or guidelines?
Can group by and orderby be used together?
Explain Normalization and DE normalization
Mention the uses of stored procedures.
Explain tables in SQL Azure?
What is the minimum recommended amount of ram for sql server 2012 enterprise?