DATABASE SYSTEMS DESIGN
IMPLEMENTATION AND MANAGEMENT
ACTUAL TEST QUESTIONS AND ANSWERS
BUNDLED STUDY MATERIAL GRADED A+
●● Atomic Transaction Property
Answer: A property that required all parts of a transaction to be treated
as a single, logical unit of work in which all operations must be
completed(committed) to produce a consistent database.
●● Binary Lock
Answer: A lock that has only two states: locked(1) and unlocked(0). If a
data item is locked by a transaction, no other transaction can use that
data item.
●● Buffer
Answer: Temporary storage area in primary memory used to speed up
disk operations.
●● Checkpoint
Answer: In transaction management, an operation in which the database
management system writes all of its updated buffers to disk.
, ●● Concurrency Control
Answer: A DBMS feature that coordinates the simultaneous execution of
transaction in a multiprocessing database system while preserving data
integrity.
●● Consistency
Answer: A database condition in which all data integrity constraints are
satisfied, To ensure consistency of a database, every transaction must
begin with the database in a known consistent state. If not, the
transaction will yield an inconsistent database that violate its integrity
and business rules.
●● Consisten Database State
Answer: A database state in which all data integrity constraints are
satisfied.
●● Database-Level Lock
Answer: A type of lock that restricts database access to the owner of the
lock and allows only one user at a time to access the database, This lock
works for batch processes but is unsuitable for online multiuser DMBSs.
●● Database Recovery
Answer: The process of restoring a database to a previous consistent
state.
IMPLEMENTATION AND MANAGEMENT
ACTUAL TEST QUESTIONS AND ANSWERS
BUNDLED STUDY MATERIAL GRADED A+
●● Atomic Transaction Property
Answer: A property that required all parts of a transaction to be treated
as a single, logical unit of work in which all operations must be
completed(committed) to produce a consistent database.
●● Binary Lock
Answer: A lock that has only two states: locked(1) and unlocked(0). If a
data item is locked by a transaction, no other transaction can use that
data item.
●● Buffer
Answer: Temporary storage area in primary memory used to speed up
disk operations.
●● Checkpoint
Answer: In transaction management, an operation in which the database
management system writes all of its updated buffers to disk.
, ●● Concurrency Control
Answer: A DBMS feature that coordinates the simultaneous execution of
transaction in a multiprocessing database system while preserving data
integrity.
●● Consistency
Answer: A database condition in which all data integrity constraints are
satisfied, To ensure consistency of a database, every transaction must
begin with the database in a known consistent state. If not, the
transaction will yield an inconsistent database that violate its integrity
and business rules.
●● Consisten Database State
Answer: A database state in which all data integrity constraints are
satisfied.
●● Database-Level Lock
Answer: A type of lock that restricts database access to the owner of the
lock and allows only one user at a time to access the database, This lock
works for batch processes but is unsuitable for online multiuser DMBSs.
●● Database Recovery
Answer: The process of restoring a database to a previous consistent
state.
