Normalisation and Transaction Processing

What is the primary goal of database normalisation?

• Increase data redundancy and decrease data integrity
• Improve data redundancy and eliminate data integrity
• Reduce data redundancy and maintain data integrity
• Eliminate data redundancy and improve data integrity

In the context of database normalisation, which normal form ensures that non-key attributes are fully dependent on the primary key?

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Fourth Normal Form (4NF)
• Third Normal Form (3NF)

Which normal form eliminates partial dependencies in a database schema?

• Fourth normal form (4NF)
• Second normal form (2NF)
• First normal form (1NF)
• Third normal form (3NF)

What is the process of breaking down database tables into two or more tables to reduce data redundancy called?

• Data aggregation
• Database normalization
• Data duplication
• Transaction Processing

Which of the following is not a property of an ACID transaction?

• Duplicity

• Atomicity

• Consistent
• Isolated

Which of the following is not a property of a well-formed database transaction?

• Concurrency
• Durability
• Atomicity
• Isolation

In database systems, what does the term "Concurrent processing" refer to?

• Ability to execute multiple database operations simultaneously
• Ability to execute multiple queries simultaneously
• Ability to execute multiple updates simultaneously
• Ability to execute multiple transactions or operations simultaneously

What does serialisation mean in the context of database operations and transactions?

• Ensuring concurrent execution of transactions without effects on each

• Combining multiple databases into one
• Encrypting data during transmission
• Storing data in a single file

What is the primary purpose of record locking in a database?

• To facilitate data backup and recovery.
• To improve database performance.
• To enforce data integrity.
• To prevent concurrent access and modification of the same data.

In the context of database transactions, what is a deadlock?

• A deadlock is a situation in which a transaction is unable to proceed because it is waiting for a resource that is already released by another transaction.
• A deadlock is a situation in which two or more transactions are able to proceed simultaneously.
• A deadlock is a situation in which a transaction is unable to proceed because it is waiting for a resource that is already released.
• A deadlock is a situation in which two or more transactions are unable to proceed because each is waiting for the other to release a resource.