SQL – What ACID stands in the Database? – Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit

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.

SQL - What ACID stands in the Database? - Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit nuodbdownloadlink

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)

SQL - What ACID stands in the Database? - Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit amazoncard

2) One grand winner will get Joes 2 Pros SQL Server 2012 Training Kit worth USD 249. (Open where Amazon ship books).

SQL - What ACID stands in the Database? - Contest to Win 24 Amazon Gift Cards and Joes 2 Pros 2012 Kit combo

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)

Previous Post
SQL SERVER – Drivers for PHP, JDBC, ODBC and OLE DB
Next Post
SQL – Difference Between INNER JOIN and JOIN

Related Posts

No results found.

47 Comments. Leave new

  • Q1 Answer:
    Transaction objects are used when committing or aborting nested transactions at other than the lowest level. A transaction is an indivisible work unit defined by the ACID test. ACID stands for:

    Atomicity: cannot be divided into smaller work units.

    Concurrency: more than one transaction can occur at a time.

    Isolation: one transaction has limited knowledge about changes made by another.

    Durability: the transaction makes persistent changes.

    Q2 Answer:
    The size of NuoDB on Windows 7 x64Platform are
    Size: 160,447,768 bytes
    Size on disk is 160,448,512 bytes

    Reply
  • Imtiaz M Qureshi
    July 19, 2013 10:02 pm

    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.

    Reply
  • 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.

    Reply
  • Thank you All for amazing participation.

    All the winners are informed individually in the emails. If you receive the email, please make sure to REPLY ALL without changing subject of the email.

    Thank YOU! It was a great contest and The conversation has been more than excellent. If you have not win in this contest. There is another contest we are launching tomorrow – you get another chance. If you are winner in this contest – you can still take part in the contest tomorrow but you will not qualify for giveaway.

    Thanks again!

    Reply

Leave a Reply

Menu