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
- 17778 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 are transaction isolation levels supported by oracle?
Explain what are the advantages of views?
How to insert multiple rows with one insert statement in oracle?
What is oracle data type?
What are the differences between blob and clob in oracle?
Explain self joins in oracle?
Can we create database in oracle using command line ?
How to turn on or off recycle bin for the session?
What are a collation and state the different types of collation sensitivity?
What is the difference between post-database commit and post-form commit?
Explain the dml?
How to get maxsal , minsal, ename department wise in single query
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is sharded cluster?
What are temporal data types in oracle?
