Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207521 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 / pralhad
Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 63 Yes | 47 No |
Post New Answer View All Answers
How to create tables for odbc connection testing?
How would you begin to troubleshoot an ORA-3113 error?
What are the advantages of oracle 12c?
query optmization techniques and quwry analyser+projects+ppts
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??
Explain the use of record option in exp command.
Differentiate between pre-select and pre-query?
What do you mean by a tablespace?
Please explain drop constraint oracle?
Explain what are clusters?
What is the difference between I and G in Oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to define an anonymous block?
What is Virtual Private Database in Oracle?
What is the difference between alert log file and tarce file ?
