Difference between primary key and unique key ?
Answer Posted / ibrahim
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.
but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to bring a tablespace online?
Explain the difference between sql and oracle?
How to define and use table alias names in oracle?
What is data block in Oracle?
How to do a full database export?
Explain the difference between sap and oracle?
What is the difference between post-database commit and post-form commit?
How to define a data source name (dsn) in odbc manager?
What privilege is needed for a user to create tables in oracle?
What to do if dba lost the system password?
How to test null values?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
Explain temporal data types in oracle
How to retrieve values from data fields in record variables?
What is meant by joins? List out the types of joins.