Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207605 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 / ankit kumar singh
Primary Key:
* Primary Key can not contain null value
* Clustured index is created in Primary key.
* Primary Key allows Each row in a table to uniquely
identified and insures that no applicable row exists.
Unique Key:
* Unique Key can contain null value.
* More than one Unique key in a table can be declared.
* Non-clustered index is created in unique key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What language does oracle use?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the uses of synonyms?
What do you mean by cdb and pdb in oracle 12c?
What is a user role in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What is truncate oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to create a table index?
What is oracle host variable?
Can the query output be sorted by multiple columns in oracle?
What are the logical operations?
How to assign a tablespace to a users in oracle?
How to display employee records who gets more salary than the average salary in the department?
