Which of the following is not a property of a transaction in a DBMS?Select one:a. Isolationb. Atomicityc. Consistencyd. Uniqueness
Question
Which of the following is not a property of a transaction in a DBMS?
Select one:
- a. Isolation
- b. Atomicity
- c. Consistency
- d. Uniqueness
Solution
The correct answer is d. Uniqueness.
In the context of a DBMS (Database Management System), a transaction must have the following properties, often referred to as ACID properties:
a. Atomicity: This means that a transaction must be treated as a single, indivisible unit of work. In other words, either all of its data modifications are performed, or none of them are.
b. Consistency: This ensures that a transaction brings the database from one valid state to another. The database should satisfy a specific set of constraints before and after the transaction.
c. Isolation: This property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially, i.e., one after the other.
However,
d. Uniqueness: This is not a property of a transaction in a DBMS. Uniqueness is a property that can be set on a database column to ensure that no two rows in the table can have the same value in that column. But it's not a property of the transaction itself.
Similar Questions
The four properties of database transactions (i.e., the ACID properties) are atomicity, consistency, integrity, and durability.
Which of the following is NOT an example of a transaction?
A concept or principle that relates to transactions is:Multiple Choiceconsistency.materiality.full disclosure.original cost.
A business transaction can have dual effect on a single accounting element or value.Select one:TrueFalse
Which of the following is not a feature of DBMS?Minimum Duplication and Redundancy of DataHigh Level of SecuritySingle-user Access onlySupport ACID Property
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.