Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15361 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / anamika niit
Primary key and unique are Entity integrity constraints
Primary key allows each row in a table to be uniquely
identified and ensures that no duplicate rows exist and no
null values are entered.
Unique key constraint is used to prevent the duplication of
key values within the rows of a table and allow null
values. (In oracle, one null is not equal to another null).
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is translate in oracle?
What is a dead lock in oracle?
What is oracle analytical function?
What happens to the data files if a tablespace is dropped?
how to join query for one source type is oracle another source type is sql server ?
Please explain oracle left join with an example?
How to get execution path reports on query statements?
What are privileges and grants?
How can we delete duplicate rows in a table?
Why do we need oracle client?
How to create a table index in oracle?
What are the restrictions on external table columns?
what is a Nested Loop join?
Explain what are the different type of segments?
Explain the use of compress option in exp command.
