Difference between primary key and unique key ?
Answer Posted / chauhan rakesh botad
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to create an oracle database manually?
What is oracle server autotrace in oracle?
How can you use check constraints for self referential integrity?
why dont we assign not null constraint as table level constraint.
How to initialize variables with default values?
Whats the benefit of dbms_stats over analyze?
How to create an initialization parameter file?
What is archive log in Oracle?
How can I see all tables in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is a synonym? What are its various types?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
master table and child table performances and comparisons in Oracle ?
Explain a data segment?