Difference between primary key and unique key ?
Answer Posted / mareeswaran-jeyakani
The primary key cannot be accept the null values.The unique key can accept null values. assume that you have a two
columns column1 having primary key constraint and column2 having unique constraint if u try to insert null into column2 it will accept that values whereas column1 will not accept the null values.
THANK YOU.ALL THE BEST...............
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
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 difference between sap and oracle?
Explain the use of file option in exp command.
How to write a query with an inner join in oracle?
What is Segment Advisor in Oracle?
Can multiple cursors being opened at the same time?
What is ASM (Automatic Storage Management) in Oracle?
What is the usage of synonyms?
What are operators in oracle?
Explain oracle data types with examples?
What is a table index?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Why is oracle used?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is the dynamic sql in oracle?