This Quiz contains totally 25 Questions each carry 1 point for you.
1.Which of the following is not an ACID property of DBMS transactions?
Atomicity
Consistency
Isolation
Distribution
Correct!
Wrong!
2.What does the "Atomicity" property in ACID mean?
The transaction is durable and remains so even in the event of power loss or system failure.
The transaction occurs entirely or not at all.
The transaction ensures that the database remains consistent after the transaction.
The transaction can operate concurrently with other transactions.
Correct!
Wrong!
3.In the context of DBMS, what is a transaction?
It's a state in the database.
It's a single unit of work that modifies the database.
It's a process that backs up the database.
It's a component of the database.
Correct!
Wrong!
4.What is the state of a transaction when it executes all its operations successfully?
Active
Partially committed
Committed
Failed
Correct!
Wrong!
5.Which of the following DBMS schedules ensure that a transaction cannot read a data item that is written by another transaction that has not yet committed?
Serializable schedules
Non-serializable schedules
Cascading schedules
Non-cascading schedules
Correct!
Wrong!
6.What is Conflict Serializability in DBMS?
A schedule that can be transformed into a serial schedule by swapping non-conflicting operations.
A schedule that can be transformed into a serial schedule by swapping conflicting operations.
A schedule that cannot be transformed into a serial schedule.
A schedule that operates independently.
Correct!
Wrong!
7.What is View Serializability in DBMS?
It ensures conflict serializability.
It ensures the transaction is atomic.
It is a wider and more general class of schedules than conflict serializability.
It defines the ACID properties.
Correct!
Wrong!
8.What does Scheduled Recoverability refer to in a DBMS?
Recovering from system failures
Recovering data from old backups
Planning the future transaction execution
Determining the degree to which ongoing transactions can be recovered in the event of a failure
Correct!
Wrong!
9.Which type of failure is related to disk crashes in the DBMS?
System Failure
Media Failure
Transaction Failure
Network Failure
Correct!
Wrong!
10.What is the primary role of a checkpoint in a DBMS?
To provide a mechanism for recovery in the event of a system crash
To validate transactions
To manage database operations
To serialize transactions
Correct!
Wrong!
11.What is the purpose of log-based recovery in a database management system (DBMS)?
Makes a record of every update occurring in the database
Checks the log and undoes the transaction in the case of a failure
Checks the log and undoes the transaction before a commit point
All of the above
Correct!
Wrong!
12.What is a deadlock in a DBMS?
A situation where two transactions wait for each other to release resources
A situation where a transaction is waiting for an operation to complete
A situation where a transaction has been committed
A situation where a transaction has been rolled back
Correct!
Wrong!
13.What does "Postponed" refer to in a DBMS?
Delaying the execution of a transaction
Delaying the execution of a query
Delaying the writing of log records to disk
Delaying the commit operation until all locks are released
Correct!
Wrong!
14.Which property of a transaction ensures that once the transaction has completed execution, the updates and modifications are permanent in the database?
Atomicity
Consistency
Isolation
Durability
Correct!
Wrong!
15.What is the "Consistency" property in ACID?
It ensures that the database properly changes states upon a successfully committed transaction.
It ensures that the transaction brings the database from one valid state to another.
It ensures that a transaction can work correctly alongside or after other transactions.
It ensures that a transaction will not be interrupted by other database activities.
Correct!
Wrong!
16.What does the "Isolation" property in ACID mean?
It ensures that the transaction brings the database from one valid state to another.
It ensures that the database properly changes states upon a successfully committed transaction.
It ensures that a transaction can work correctly alongside or after other transactions.
It ensures that a transaction will not be interrupted by other database activities.
Correct!
Wrong!
17.What is the purpose of using logs in DBMS?
To store temporary data
To recover the system from crashes or failures
To store metadata
To keep a record of transactions for auditing purposes
Correct!
Wrong!
18.What is a cascading rollback?
A rollback that affects all transactions
A rollback that only affects the current transaction
A single rollback that leads to a series of rollbacks
A rollback that affects none of the transactions
Correct!
Wrong!
19.What does the "active" state of a transaction mean?
The transaction has been committed
The transaction is being executed
The transaction has been rolled back
The transaction is idle
Correct!
Wrong!
20.In which state is a transaction in when it is partially committed?
After the final statement has been executed
After the transaction has been rolled back
After the start statement has been executed
Before the final statement has been executed
Correct!
Wrong!
21.What is two-phase locking (2PL) used for?
Ensuring data consistency
Maintaining atomicity
Achieving transaction isolation
Providing durability
Correct!
Wrong!
22.Which of the following are deadlock prevention techniques?
Wait-Die and Wound-Wait schemes
Wait-For Graph
Timeout method
All of the above
Correct!
Wrong!
23.A _________ schedule is one where the transactions lined up are in a sequence one after the other.
Serializable
Non-serializable
Cascading
Serial
Correct!
Wrong!
24.Which of the following best describes a transaction failure?
Failure due to a system crash
Failure due to an error or interruption in the transaction
Failure due to a disk crash
Failure due to a power loss
Correct!
Wrong!
25.What is the purpose of a dirty read?
To read uncommitted data from a transaction
To read data that has been modified by a current transaction
To read data from the database without any modifications
To read data that has been committed to the database
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
Ignore & go to results
DBMS Transaction management and Concurrency control – Quiz
You got %%score%% of %%total%% right
%%description%%
%%description%%
Loading...