Difference between primary key and unique key ?

Answer Posted / boomiraj.p

Primary key: Do not allow the
duplicates and null values.
Unique key : Do not accept the
duplicates,but allow null value

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

1623


Which are the five query types available in oracle?

536


How index is implemented in oracle database?

603


How to use regular expression in pattern match conditions in oracle?

585


How to enter a new row into a table interactively?

558






Can we insert data in view oracle?

547


What happens to the data files if a tablespace is dropped?

588


How to update a table row with a record?

602


What is transport network substrate (tns) in oracle?

594


Briefly explain what is literal? Give an example where it can be used?

550


Use of an integrity constraint is better to validate data. Explain

555


Can a formula column referred to columns in higher group ?

2093


What are the different types of trigger and explain its various uses and functions?

557


How to initialize variables with default values?

644


How to download oracle database 10g xe?

604