If an UNIQUE KEY constraint on DATE column is created, will
it accept duplicate values?
- 2 Answers
- 3923 Views
- I also Faced
- E-Mail Answers
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 |
Explain data dictionary.
Explain degree of a relation?
Define dml compiler.
What the default privileges which get assigned ?
What is difference between database and schema?
What are the four objectives of the selection of a data type?
What is the use of ANALYSE ( Ver 7) option in EXP command ?
What are the steps involved in Database Shutdown ?
How to create a database from my program?
What are the limitations of rdbms?
What are the types of distributed database?
what is s/w lifecycle?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
