Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210509 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 / mohan singh
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
Unique key contain non repetitive value but can contain
only one null value in the column.And unique key is created
on non clustered index.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What is oracle datasource?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Which is better Oracle or MS SQL? Why?
Is rowid unique in oracle?
if you ctreate table identity
What is BBED in Oracle?
Does oracle database need java?
What are privileges and grants?
What is set operator oracle?
What is a cognitive schema?
How to create a new oracle data file?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are the parameters that we can pass through a stored procedure?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Why does oracle 9i treat an empty string as null?
