Difference between primary key and unique key ?
Answer Posted / rinu
1)unique key can be null but primariy key cant be null.
2)primariy key can be refrenced to other table as FK.
3)we can have multiple unique key in a table but PK is one
and only one.
4)PK in itself is unique key.
5)a table can have more then one unique key column but a
table can have only one primary key column.
6)primary key creates clustered index but unique key
creates non clustered index.
| Is This Answer Correct ? | 12 Yes | 7 No |
Post New Answer View All Answers
What is an oracle cursor variable?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Explain the use of inctype option in exp command.
Respected sir, Please send me technical questions related to oracle apps..
What is oracle and what are its different editions?
What is the difference between I and G in Oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is an index associated with a constraint?
how may join possible between (requisition with purchase order)
What is the difference between alert log file and tarce file ?
Can we save images in a database and if yes, how?
What is instant client oracle?
How to assign values to data fields in record variables?
How to define an anonymous procedure with variables?
What is a tns service name?