Multiple choice technology databases

If an UNIQUE KEY constraint on DATE column is created, it will accept the rows that are inserted with SYSDATE ?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

If multiple rows are inserted using SYSDATE in rapid succession (within the same second), they would have identical timestamp values, violating the UNIQUE constraint. The UNIQUE constraint prevents any duplicate values, including those from SYSDATE.