We love puzzles. One of the brain’s main task is to solve puzzles. Sometime puzzles are very complicated (e.g Solving Rubik Cube or Sodoku) and sometimes the puzzles are very simple (multiplying 4 by 8 or finding the shortest route while driving). It is always to solve puzzle and it creates an experience which humans are not able to forget easily. The best puzzles are the one where one has to do multiple things to reach to the final goal. Let us do something similar today. We will have a contest where you can participate and win something interesting.
Contest
This contest have two parts.
Question 1: What ACID stands in the Database?
This question seems very easy but here is the twist. Your answer should explain minimum one of the properties of the ACID in detail. If you wish you can explain all the four properties of the ACID but to qualify you need to explain minimum of the one properties.
Question 2: What is the size of the installation file of NuoDB for any specific platform.
You can answer this question following format – NuoDB installation file is of size __ MB for ___ Platform.
Click on the Download the Link and download your installation file for NuoDB. You can post figure out the file size from the properties of the file.
We have exciting content prizes for the winners.
Prizes
1) 24 Amazon Gift Cards of USD 10 for next 24 hours. One card at every hour. (Open anywhere in the world)
2) One grand winner will get Joes 2 Pros SQL Server 2012 Training Kit worth USD 249. (Open where Amazon ship books).
Amazon | 1 | 2 | 3 | 4 | 5
Rules
The contest will be open till July 21, 2013. All the valid comments will be hidden till the result is announced.
The winners will be announced on July 24, 2013.
Hint: Download NuoDB
Reference: Pinal Dave (https://blog.sqlauthority.com)
47 Comments. Leave new
1. NuoDB installation file size is 153MB for Windows(64 bit) Platform.
2. ACID is an acronym for atomicity, consistency, isolation, and durability. It generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved. When a transaction processing system creates a transaction, it will ensure that the transaction will have these characteristics.
ATOMICITY: The atomicity property identifies that the transaction is atomic. An Atomic transaction is either fully completed, or is not begun at all. If for any reason an error occurs and the transaction is unable to complete all of its steps, the then system is returned to the state it was in before the transaction was started.
CONSISTENCY: A transaction enforces Consistency in the system state by ensuring that at the end of any transaction the system is in a valid state. If the transaction completes successfully, then all changes to the system will have been properly made, and the system will be in a valid state. If any error occurs in a transaction, then any changes already made will be automatically rolled back.
ISOLATION: When a transaction runs in Isolation, it appears to be the only action that the system is carrying out at one time. If there are two transactions that are both performing the same function and are running at the same time, transaction isolation will ensure that each transaction thinks it has exclusive use of the system.
DURABILITY: A transaction is Durable in that once it has been successfully completed, all of the changes it made to the system are permanent. There are safeguards that will prevent the loss of information, even in the case of system failure.
1. NuoDB installation file size is 153MB for Windows(64 bit) Platform.
2. ACID is an acronym for atomicity, consistency, isolation, and durability. It generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved. When a transaction processing system creates a transaction, it will ensure that the transaction will have these characteristics.
ATOMICITY: The atomicity property identifies that the transaction is atomic. An Atomic transaction is either fully completed, or is not begun at all. If for any reason an error occurs and the transaction is unable to complete all of its steps, the then system is returned to the state it was in before the transaction was started.
CONSISTENCY: A transaction enforces Consistency in the system state by ensuring that at the end of any transaction the system is in a valid state. If the transaction completes successfully, then all changes to the system will have been properly made, and the system will be in a valid state. If any error occurs in a transaction, then any changes already made will be automatically rolled back.
ISOLATION: When a transaction runs in Isolation, it appears to be the only action that the system is carrying out at one time. If there are two transactions that are both performing the same function and are running at the same time, transaction isolation will ensure that each transaction thinks it has exclusive use of the system.
DURABILITY: A transaction is Durable in that once it has been successfully completed, all of the changes it made to the system are permanent. There are safeguards that will prevent the loss of information, even in the case of system failure.