Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207481 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 do we create privileges in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to select an oracle system id (sid)?
Explain the use of file option in exp command.
What is oracle instant client?
What is max rowid in oracle?
Does oracle charge for java?
What is a sub query and what are the different types of subqueries?
what is the difference between restoring and recovering?
Why do we use coalesce function in oracle?
How to use fetch statement in a loop?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a table index in oracle?
How to bring a tablespace offline?
