Difference between primary key and unique key ?

Answer Posted / nithin

1. There can be more than one unique key in a row or table
but there can be only one primary key in a row or table.

2. Primary key does not accept NULL values but Unique key
accepts even NULL values.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is tns name?

547


How does oracle handle read consistency?

680


Explain integrity constraint?

648


How to calculate date and time differences in oracle?

535


How to write a query with a left outer join in oracle?

607






State all possible different index configurations a table can possibly have?

572


Explain compound trigger in oracle?

555


What is a trigger oracle?

565


What is recycle bin in Oracle?

722


How to define and use table alias names in oracle?

512


How to see the table columns used in an index?

600


What are joins, explain all types of joins?

1724


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2067


What is meant by raw datatype?

574


What happens to the current transaction if a ddl statement is executed?

580