If an UNIQUE KEY constraint on DATE column is created, will it accept the rows that are inserted with SYSDATE ?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Which of the following statements are true?
- For which constraints are indexes created when the constraint is added?
- The columns with unique constraint allows more than one null values to be inserted.
- The constraint used to avoid keying in repeated values into a column must be declared_____________.
- Which constraint can only be applied at the column level?
- reference to sysdate,nextval,currval is allowed on constraint definition
- For which two constraints,does the oracle server implicitly creates an index ?
- Which constraint can be defined only at the column level?