Difference between primary key and unique key ?
- 77 Answers
- 191043 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada and the answer
is mentioned below
Primary key: A Primary key is a column or group of columns
used to uniquely identify each row in a table like
It defines the column as a Mandatory column.
The data held across the column must be unique.
By default it creates clustered index.
It does not allow null values and duplicate values
Unique key: It also for the record uniqueness.
It allows only one null value
By default it creates non clustered index
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Define oracle database
What is materialized view in Oracle?
Which are the five query types available in oracle?
How to rename an existing table?
How to check the oracle tns settings?
How would you go about verifying the network name that the local_listener is currently using?
How many anonymous blocks can be defined?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Is primary key indexed by default in oracle?
How to pass parameters to procedures in oracle?
How translate command is different from replace?
What happens in oracle commit?
What is the difference between Delete, Truncate and Drop in Oracle?
What is rich query?
How to pass a cursor variable to a procedure?
