Difference between primary key and unique key ?
Answer Posted / pandiyan
Primary key doesnot allow null value but unique key allows
null value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are a cluster and non-cluster index?
How to define an oracle cursor variable?
Explain the use of log option in exp command.
How many types of synonyms in Oracle?
What is the difference between hot backup and cold backup in oracle?
What is the difference between pre-select and pre-query?
What is BBED in Oracle?
Explain constraining triggers.
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to see free space of each tablespace?
How to set up autotrace for a user account?
How is it different from a normal table?
How to start an oracle instance?
How to call a sub procedure?
How to start a new transaction in oracle?