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 |
what are the two integrity rules used in DBMS?
what is the use of EXP command ?
Which two can be implemented as a centrally located logical architecture?
List few restrictions that are imposed while creating views?
What is the difference between shrink database and shrink file?
Enlist various transaction phases.
How does distributed database work?
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
What is data model and types?
Why is group-clause used?
Describe the Process of Connecting a Database to a Data Analysis Tool.
What do you understand by ‘atomicity’ and ‘aggregation’?
Oracle (3259)
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)