Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210594 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 / ela tiku
1. Primary key does not allow Nill value whereas Unique key
allows Null values.
2. There can more than one Unique key for a table however
there is only one primary key for ant tanle.
2. Whenever a primary key is assigned by default a
Clustered Index is created whereas When a Unique key is
created a Non Index clustered index is created...
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
How to convert characters to dates in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is an oracle table?
How to name query output columns in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How a tablespace is related to data files?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Explain the types of exception?
How to return top 5 rows in oracle?
What is format trigger?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Explain compound trigger in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
