Quiz

Database Fundamentals

0% completed

Quiz

Question 1

What is the primary goal of concurrency control in a database system?

A

To ensure efficient query execution

B

To manage simultaneous access to the database and maintain consistency

C

To replicate data across nodes for fault tolerance

D

To optimize storage usage in multi-user environments

Question 2

In lock-based concurrency control, what happens when a transaction tries to acquire a lock already held by another transaction?

A

The transaction waits until the lock is released

B

The transaction rolls back immediately

C

The database automatically commits the waiting transaction

D

The database generates a conflict and stops the system

Question 3

What does Multiversion Concurrency Control (MVCC) primarily achieve?

A

Ensures that only one version of data is available at any time

B

Requires all transactions to wait for a global lock

C

Prevents read operations while a write transaction is ongoing

D

Allows concurrent reads and writes without locking

Question 4

In optimistic concurrency control, which phase checks for conflicts?

A

Read Phase

B

Validation Phase

C

Write Phase

D

Execution Phase

Question 5

What happens in a deadlock situation in lock-based concurrency control?

A

Transactions complete without issues

B

The system restarts all transactions

C

One or more transactions must be rolled back

D

Transactions wait indefinitely until resolved

Question 6

Which concurrency control technique is most efficient for low-contention environments?

A

Optimistic Concurrency Control

B

Pessimistic Concurrency Control

C

Multiversion Concurrency Control

D

Timestamp-Based Concurrency Control

.....

Like the course? Get enrolled and start learning!