Difference between primary key and unique key ?
Answer Posted / jason james john
unique key is a key that uniquely defines the characteristics of each row whereas primary key consists of characteristics that cannot collectively be duplicated by any other row.primary key will not allow null values whereas unique key will allow nulls.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What happens if you set the sga too low in oracle?
What is a nvl function?
How do you tell what your machine name is and what is its IP address?
How to pass parameters to procedures in oracle?
what are actual and formal parameters?
What is a procedure in oracle?
Explain the use of indexes option in imp command.
What is the string concatenation operator in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What do you mean by a deadlock?
How do I manually create a database in oracle?
What is ordinary table in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to retrieve data from an explicit cursor?