Software Development Exam  >  Software Development Questions  >  Which of the following is NOT a characteristi... Start Learning for Free
Which of the following is NOT a characteristic of a database transaction?
  • a)
    Atomicity
  • b)
    Durability
  • c)
    Consistency
  • d)
    Flexibility
Correct answer is option 'D'. Can you explain this answer?
Verified Answer
Which of the following is NOT a characteristic of a database transacti...
Flexibility is not a characteristic of a database transaction. The correct characteristics are Atomicity, Consistency, Isolation, and Durability (ACID).
View all questions of this test
Most Upvoted Answer
Which of the following is NOT a characteristic of a database transacti...
Introduction:
A database transaction is a logical unit of work that consists of multiple database operations. It is a fundamental concept in database management systems (DBMS) that ensures data integrity and consistency. A transaction should have certain characteristics to ensure reliability and maintainability of the database.

Detailed Explanation:
a) Atomicity:
Atomicity refers to the "all-or-nothing" principle of a transaction. It means that a transaction is considered as a single indivisible operation. Either all the database operations within a transaction are successfully completed, or none of them are applied. If any operation fails within a transaction, all the changes made by the transaction are rolled back to the previous state, ensuring data consistency.

b) Durability:
Durability ensures that once a transaction is committed and the changes are made to the database, they are permanent and will survive any subsequent failures such as power outages or system crashes. The changes made by the transaction are stored in non-volatile memory, like a hard disk, to ensure their persistence.

c) Consistency:
Consistency ensures that a transaction brings the database from one consistent state to another consistent state. It enforces the integrity constraints and rules defined on the database, preventing any invalid or inconsistent data from being stored. Consistency guarantees that the database remains in a valid and reliable state.

d) Flexibility:
Flexibility is not a characteristic of a database transaction. The options listed in the question are all characteristics of a database transaction, except for flexibility. Flexibility is a more general term and does not specifically apply to transactions. It could refer to the ability to modify the database schema, change the data types, or add new tables, which are not directly related to the properties of a transaction.

Conclusion:
In conclusion, flexibility is not a characteristic of a database transaction. Atomicity, durability, and consistency are the fundamental properties of a transaction that ensure the reliability, integrity, and persistence of data in a database.
Explore Courses for Software Development exam

Top Courses for Software Development

Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer?
Question Description
Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? for Software Development 2025 is part of Software Development preparation. The Question and answers have been prepared according to the Software Development exam syllabus. Information about Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? covers all topics & solutions for Software Development 2025 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer?.
Solutions for Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Software Development. Download more important topics, notes, lectures and mock test series for Software Development Exam by signing up for free.
Here you can find the meaning of Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer?, a detailed solution for Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? has been provided alongside types of Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Which of the following is NOT a characteristic of a database transaction?a)Atomicityb)Durabilityc)Consistencyd)FlexibilityCorrect answer is option 'D'. Can you explain this answer? tests, examples and also practice Software Development tests.
Explore Courses for Software Development exam

Top Courses for Software Development

Explore Courses
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev