Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207512 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
What is difference between sid and service name in oracle?
Is primary key indexed by default in oracle?
How can we find out the duplicate values in an oracle table?
What privilege is needed for a user to delete rows from tables in another schema?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How many anonymous blocks can be defined?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
what is the difference between functional dependecy and multilevel dependency?
How to assign data of the deleted row to variables?
What is a initialization parameter file in oracle?
What happens to the current transaction if a ddl statement is executed?
Explain do view contain data?
How can I combine multiple rows into a comma-delimited list in oracle?
What is background process in Oracle?
What operating systems are supported by oracle database 10g xe?
