Difference between primary key and unique key ?

Answer Posted / rakesh dwivedi

1.Primary key can not have null.Instead of it unique can have null at lest single time null.
2 In a table only one primary key exist.Unique can be multiple in table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define oracle database

596


How to delete a column in an existing table in oracle?

604


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

580


6. Display the client name and order date for all orders using the traditional method.

1753


How to rename a tablespace in oracle?

619






Why is oracle database so popular?

566


How to connect to a remote server?

562


What is oracle and what are its different editions?

581


How to assign values to data fields in record variables?

584


Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

860


What is hash cluster in oracle?

596


What is a oracle database?

609


Can the query output be sorted by multiple columns in oracle?

574


Why cursor variables are easier to use than cursors?

573


How do I find the database name in oracle?

602