_____ is a unique identifier created by database management system to identify…

2021

_____ is a unique identifier created by database management system to identify the relative starting time of a transaction.

  1. A.

    Timestamp

  2. B.

    Spoofing

  3. C.

    Shadow paging

  4. D.

    Deadlock

Attempted by 539 students.

Show answer & explanation

Correct answer: A

In database management systems, transactions need to be ordered to ensure consistency and isolation. A timestamp is a unique value assigned to each transaction to represent its relative start time. This helps in concurrency control mechanisms like timestamp ordering. Timestamps are generated by the DBMS and are used to determine the sequence of transactions. Other options like spoofing, shadow paging, and deadlock are unrelated to this purpose. Spoofing is a security attack, shadow paging is a recovery technique, and deadlock is a concurrency issue. Therefore, the correct term is timestamp.

Explore the full course: Up Lt Grade Assistant Teacher 2025