Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210447 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
Can we write insert statement in function in oracle?
What is a tns service name?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are the oracle built-in data types?
What is an oracle user role?
What is Trigger in Oracle?
What is the difference between substr and instr?
How to assign values to data fields in record variables?
What is a tns file?
How to get execution path reports on query statements?
What happens to the current transaction if a ddl statement is executed?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a database schema in oracle?
How to assign a tablespace to a users in oracle?
What is java oracle used for?
