If an UNIQUE KEY constraint on DATE column is created, will
it accept duplicate values?
Answers were Sorted based on User's Feedback
Answer / krishnaalluu
obsulutely No, For which ever data type column you can
difine the constraint, the behaviour of the constraint
would not be changed. So I will not allow duplicate values.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to export data from database and import into another?
How to Optimize Database Queries for Performance?
How to move a multi-file database?
What is Two-Phase Commit ?
What are the limitations of rdbms?
What is Database testing and What are ways of writing test cases for database testing?
Define scalar functions.
What are the drawback of rdbms?
How do you backup a database?
How many rows can a database hold?
In which format data is stored in database?
Explain the terms database and dbms?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)