Difference between primary key and unique key ?
Answer Posted / mudigouda patil
PRIMARY KEY
1)TABLE CAN NOT HAVE MORE THAN ONE PRIMARY KEY.
2)PK DOES NOT ALLOW NULL VALUES.
UNIQUE KEY
1)TABLES CAN HAVE MORE THAN ONE UNIQUE KEY.
2)UNIQUE KEY ALLOWS NULL VALUES.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the database name in oracle?
How to define a data field as not null?
How to sort the query output in oracle?
What is the oracle implicit cursor?
Does oracle partitioning improve performance?
Explain the use of consistent option in exp command.
How to execute the package in oracle?
How to delete multiple rows from a table in oracle?
What are the differences between number and binary_float in oracle?
Explain cascading triggers.
How different is ms access and oracle?
How to add a new column to an existing table in oracle?
What is the relation of a user account and a schema in oracle?
What is an anonymous block?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me