Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15332 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
How many types of database triggers exist?
Explain an exception?
What is the difference between translate and replace in oracle?
How to define an anonymous procedure with variables?
what is the use of system.effective.date variable in oracle?
How to connect to the server with user account: sys?
Explain a synonym?
What is the dynamic sql in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Which is better Oracle or MS SQL? Why?
What are the different types of record groups in oracle? Explain each of them
How do we get field detail of a table?
How to upsert (update or insert into a table)?
Explain overloading. Can functions be overloaded?
How to bring a tablespace online?
