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
- 18036 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 to assign a table row to a record variable?
Can we save images in a database and if yes, how?
How to use subqueries with the in operator using oracle?
Does oracle charge for java?
How to assign a tablespace to a users in oracle?
Can we create database in oracle using command line ?
How to end the current transaction in oracle?
State some uses of redo log files?
What is a system tablespace?
What is a cursor in oracle?
What is BBED in Oracle?
Explain about functional dependency and its relation with table design?
What is a read write transaction in oracle?
How do I recompile a procedure in oracle?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
