Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 18079 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / neeraj
No, Both are different, If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.
I think you got the difference.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is oracle an open source?
What happens to the indexes if a table is recovered?
What is different types of joins?
What is rowid and rownum in oracle?
What are the predefined tablespaces in a database?
Explain the difference between replace() and translate() functions in oracle?
What do you know about normalization? Explain in detail?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is meant by raw datatype?
What are the execution control statements in oracle?
What is a connect identifier?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
what is the difference between restoring and recovering?
How to call a stored function in oracle?
What are the attributes that are found in a cursor?
