Question 6
Fifth Normal Form (5NF) is also known as -
5NF is termed Project-Join Normal Form because it addresses join dependencies, ensuring a table cannot be losslessly decomposed into smaller tables.
Fifth Normal Form (5NF) is also known as -
5NF is termed Project-Join Normal Form because it addresses join dependencies, ensuring a table cannot be losslessly decomposed into smaller tables.
In a relational schema, if R is decomposed into R1 and R2, the decomposition is lossless if R1 ∩ R2 determines -
A binary decomposition of R into R1 and R2 is lossless join if and only if (R1 ∩ R2) -> R1 or (R1 ∩ R2) -> R2.
Which property of ACID ensures that concurrent execution of transactions leaves the database in the same state as if executed serially?
Isolation ensures that concurrent transactions execute independently without interfering with each other's intermediate uncommitted states.
Which ACID property guarantees that once a transaction commits, its changes survive system crashes?
Durability guarantees that committed data changes are permanently saved in non-volatile storage and survive subsequent system failures.
What is a dirty read in database transactions?
A dirty read occurs when Transaction A reads modifications made by Transaction B before Transaction B commits. If B rolls back, A holds invalid data.