Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210100 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
Explain the use of online redo log files in oracle.
Explain temporal data types in oracle
What is using clause and give example?
Explain the use of Merge statement in oracle 11g
what are the default admin accounts in Oracle 10g ?
How to put more than 1000 values into an oracle in clause?
What is the maximum limit on the number of columns in a table?
How to work with data objects interactively?
How to sort output in descending order in oracle?
Why packages are used in oracle?
Can I create users through internet explorer in oracle 10g?
Explain the use of owner option in exp command.
What is execute immediate in oracle?
How to define a specific record type?
What is meant by joins?
