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 is database
What are the integrity rules in dbms?
Is filemaker pro a relational database?
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
How many rows can a database hold?
Define sub-query.
What do you understand by b-trees?
explain about the critical recovery scenario you had experienced
What is Schema in DBMS?
What is procedure in database?
Define object-oriented model.
Mention a query to add email validation to your database
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)