what is the difference between unique and primary key
Answers were Sorted based on User's Feedback
Answer / ravi kanth
Primary key is the combination of unique and not null.But
unique key accepts null values also.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / suresh kumar somayajula
Unique Key allows NULL value and a table can have more than
one UNIQUE KEY Constraint.
Primary Key is the combination of UNIQUE+NOT NULL,means it
won't allow NULL Values and a table can have only one
Primary Key.But a table can have Composite Primary Key.
Thank you,
Suresh
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / priyanka
Both are uniqe identification keys but Primary key should
not be null but uniqe key should.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / divyarao
primary key accepts only values which has no duplication ,and does not accept null values . for a a table there should be only one primary key constraint.
whereas in unique key ,it accepts null values .here also there should not be any duplication ,a table may have more than one unique key constarint
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vinod
uniqe key allow one null value only but primary key cannot
allow any null value
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the normal procedure followed by a java client to access the db?
What is db driver?
What is distributed queries?
What is the use of drop command?
Should database table names be capitalized?
Define database lock?
What are the features of a database management system?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
How to handle data if f table are more than one and each table contain thousands of entries?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
What does partition mean in 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)