Difference between primary key and unique key ?
Answer Posted / mohammad ali
-The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values.
-We can declare only one primary key in a table
but a table can have multiple unique key
-Clustered index is created on Primary key constraint and
non clustered unique indexes is created on Unique key constraint.
-Primary key columns automatically become NOT NULL (unique
keys can contain nulls).
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is meant by raw datatype?
How to delete multiple rows from a table in oracle?
what are bitmap indexes? How does they work?
What is a nvl function? How can it be used?
What is a nvl function?
What are joins, explain all types of joins?
How to write numeric literals in oracle?
What are triggers in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to run queries on external tables?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Differentiate between post-database commit and post-form commit?
What are the different types of database objects?
What is a cursor and what are the steps need to be taken?
What is the fastest query method to fetch data from the table?