Difference between primary key and unique key ?

Answer Posted / rajkumar tiwari

Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you tell what your machine name is and what is its IP address?

1522


How to lock and unlock a user account in oracle?

626


What exactly do quotation marks around the table name do?

554


How to create a stored function in oracle?

593


What is SQL Tuning Advisor in Oracle?

640






How to rename an existing table?

617


What is oracle update statement with inner join ?

588


What are advantages of dateset in datastage?

1757


how can we store any pdf file in oracle

1650


What to do if the startbd.bat failed to start the xe instance?

615


What are internal user account in oracle?

576


Query to retrieve record for a many to many relationship ?

2083


What is meant by an index?

636


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

659


What is recycle bin in Oracle?

725