Difference between primary key and unique key ?
Answer Posted / niranjan dhungia
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 ? | 1017 Yes | 126 No |
Post New Answer View All Answers
How to retrieve data from an cursor to a record?
What is the difference between view and materialized view in Oracle?
How to write an inner join with the where clause in oracle?
What is redo log?
Whats the benefit of dbms_stats over analyze?
What happens to the data files if a tablespace is dropped?
How to apply filtering criteria at group level in oracle?
How to view all columns in an existing table?
Explain oracle insert into command?
What is meant by raw datatype?
What is recycle bin in Oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are the attributes that are found in a cursor?
what are archived logs?
What is the difference between a hot backup and a cold backup in oracle?